Public Enum Keyword not recognized in VBA of Excel 2004

[Guest]

I tried to use an Excel worksheet on my Mac that was originally created on a
PC. The Mac seems to have trouble with the "Public Enum" function in the
Visual Basic Editor. I can only assume Enumeration is not supported in VBA
for the Mac. Is this correct? If so, does anyone know of a similiar data
structure I could use?

 

[JE McGimpsey]

All MacXL VBA is VBA 5.0. Enums were introduced in VBA6.

Enums are just integers, though, so you can assign a Data Type
consisting of integers.

 

[Mike]

Thanks. I assume that the data structure "Dictionary" isn't supported either....