Enum's in VBA

Hi all,

I have looked through previous threads and can't find an answer to this...

For some reason I can't created Enumeration values in VBA (Excel). It works fine when I declare them in VB, but in the VB editor within Excel it won't allow the creation...

Anybody know why this is?...Is it just a reference which needs adding? How can I create Enum's in VBA?

Thanks to anybody for help
Steve