Enum Members Declaration

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ronald Dodge - 14 Nov 2007 18:29 GMT

Would it be wise to use Dim statements to declare the members of an
Enumeration as Long, or would that create issues?

I read in the help files that they are automatically defined as Long data
type, but the one issue I'm having without declaring them first with a Dim
statement is when I put in the name and if the name hasn't been used else
where in the code other than within the Enum block, the capitalization
changes on me, which I use the capitalization to help in catching possible
misspellings.

Signature

Sincerely,

Ronald R. Dodge, Jr.
Master MOUS 2000

Reply to this Message

Chip Pearson - 14 Nov 2007 22:45 GMT

It has been a problem in VBA and VB6 for a very long time that if you type
in the name of an element of an Enum type the declaration within the Enum
takes the capitalization of the entered variable. For example,

Public Enum SomeType
Val1 = 1
Val2
Val3
End Enum

Then type in the following code

Dim TheVar As SomeType
TheVar = val1

The capitalization of Val1 within the Enum is lost. It is a bug, for sure,
but apparently never prioritized enough to be fixed.

Signature

Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)

> Would it be wise to use Dim statements to declare the members of an
> Enumeration as Long, or would that create issues?
[quoted text clipped - 5 lines]
> changes on me, which I use the capitalization to help in catching possible
> misspellings.

Reply to this Message

Ronald Dodge - 15 Nov 2007 12:09 GMT

Thank you for the update. This just means that I have to be extra careful
when using enums, which I'm already finding that I'm having a lot of uses
for Enums with as much as I'm having to modulate with a report program that
I'm currently working on.

Signature

Sincerely,

Ronald R. Dodge, Jr.
Master MOUS 2000

> It has been a problem in VBA and VB6 for a very long time that if you type
> in the name of an element of an Enum type the declaration within the Enum
[quoted text clipped - 23 lines]
>> capitalization changes on me, which I use the capitalization to help in
>> catching possible misspellings.

Reply to this Message