Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Name From Enum Value

Status
Not open for further replies.

Craig0201

Technical User
Oct 11, 2000
1,261
GB
Hello!

Anyone know how I can return the name of the constant from an enum value?

Craig
 
Are you talking about extracting this information with VBA code? No, you can't do that--unless you're expert enough to extract the information from a TLB/OLB/OCX file that defines it.

What I have done in this situation is to create a table of Enum constant names and values, and look up the constant.

Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top