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.


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



"Ronald Dodge" wrote in message
...
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.

--

Sincerely,

Ronald R. Dodge, Jr.
Master MOUS 2000