Archive for the ‘Enumerations’ Category.

FTP Via VBA

January 29, 2006, 11:24 pm by Dick Kusleika

One of my new year's resolutions was to write a procedure to ftp picture files to this blog to simplify the procedure. It took two days, but I finally got it done. I don't know if it's well done, but it works. I got a little help along the way, specifically:
Forestasia has [...]

Category: Enumerations, File Operations, User Defined Functions, VBA Advanced, VBA Functions and Keywords  |  12 Comments

Custom Enumerations

July 20, 2004, 1:10 pm by Dick Kusleika

Consider this statement:
MsgBox "Hello!", vbCritical + vbYesNo
vbCritical and vbYesNo are members of a built-in enumeration called vbMsgBoxStyle. You can create your own enumerations containing constants of your choice for use in your applications. To do so, you use the Enum statement at the module level.
Enum dkMsgText    dkHello = 1    dkWorld = 2    dkExclaim = 4End Enum
In [...]

Category: Enumerations, VBA Advanced  |  6 Comments