Thread: Enum Names
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Goofy Goofy is offline
external usenet poster
 
Posts: 54
Default Enum Names

Thanks

"Andy Pope" wrote in message
...
Hi,

Check Chip Pearson's site.
http://www.cpearson.com/excel/download.htm

In particular the TLIUtils example.
"Provides VBA procedures for working with type libraries, via the TypeLib
Information object. Documentation of the available procedures is available
in the VBA code modules."

Cheers
Andy

Goofy wrote:
how can I retreive the string value of the enum internal identifier, in
other words if I have a value of 2 I want the corresponding "secondKey"


Public Enum MyEnum

firstKey = 1
secondKey = 2

End Enum


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info