Maybe I’m lacking vision here, but Enum seems better suited to VB.Net than VBA. A variable dimmed to the Enum type will store a number corresponding to the type you designate, but to use that value, you have to keep going back to see what it represents. Or am I missing something?
http://www.cpearson.com/excel/Enums.aspx
You can only use an Enum statement at module level. Try designating types outside a procedure.