Does ENUM statement work in Mac OS X??

[Steven Sartorius]

Subject line kind of says it all. I have a spreadsheet developed on a
Windows box that uses an 'Enum' statement. When I open the sheet in Excel
on OS X 10.3 the Enum statement is highlighted and a dialog box pops up
saying "Compile Error: Expected identifier".

Is the 'Enum' statement support on the Mac platform or am I seeing some
other kind of bug??

Thanks for any help,

Steve

 

[JE McGimpsey]

Subject line kind of says it all. I have a spreadsheet developed on a
Windows box that uses an 'Enum' statement. When I open the sheet in Excel
on OS X 10.3 the Enum statement is highlighted and a dialog box pops up
saying "Compile Error: Expected identifier".

Is the 'Enum' statement support on the Mac platform or am I seeing some
other kind of bug??

ENUM was introduced in VBA6, so it will not work on MacXL or WinXL97,
which use VBA5.

You'll need to modify the code to work with regular variables.