Enum not usable in Excel 97?

G

George Nicholson

I have an Excel 2000/XP project that someone "needs" to use in Excel 97.
The only real problem I have encountered is that Enum doesn't seem to be
recognized by VBA in Excel 97 SR-2.

Can someone confirm this for me? I thought Enum was added to VB5 so I am
sort of suprised that it isn't recognized by Excel 97. In addition, I've
seen MS documentation that Enum became a reserved keyword for Access 97, so
I am a bit confused and wondering if my installation of Office 97 is using
the correct references.

Any suggestions or workarounds from those-who-have-been-there-and-done-that?
 
C

Chip Pearson

George,

Enum constants were added in VBA6, which is Excel 2000 and later.
In Excel97 and earlier, you have to declare those variables a
consts with explicit values.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 97 Enum 5
Can I declare an event in Excel 97? 2
Find Function 4
User Defined Type in place of Enum 1
Worksheet Change in Excel 97 does not run first time 4
Excel 97 3
Replace Function in Excel 97 6
excel 97, VB project unable to view in another comp 2

Top