Hi Philip,

Enums weren't supported at all in Excel 97 VBA. They first appeared in
Excel 2000.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *


"Philip Mariconda" wrote in message
...
Excel 97 help and MSDN provide surprisingly little
information on the proper declaration of Enum constants.
It seems they need to be declared at module level and not
at procedure level.

However, when I type...

Public Enum iRegion

...just like an MSDN code example it's a syntax error.
Are Enum types only used in class modules?

Thanks!
Phil