VBA: How to debug.Print enumeration names?

tinfanide · #1 01-21-2012, 06:48 AM

Code:

Debug.Print (Selection.Type)

It just prints the value of the Selection Enumeration. I want something like "wdSelectionIP" instead of just "1".

macropod · #2 01-26-2012, 01:56 PM

Hi tinfanide,

AFAIK, the numeric type is the best you'll get via Debug.Print. For anything fancier, you'd need to create a Select Case statement or something such with your own enumeration list to retrieve the names from the numbers and use a MsgBox instead of Debug.Print.

tinfanide · #3 01-27-2012, 12:39 AM

Quote:

Originally Posted by macropod

Hi tinfanide,

AFAIK, the numeric type is the best you'll get via Debug.Print. For anything fancier, you'd need to create a Select Case statement or something such with your own enumeration list to retrieve the names from the numbers and use a MsgBox instead of Debug.Print.

So for Microsoft developers, they're just reading enumeration (numeric types) for reference and check it up on the MSDN tables?
If I need the names, I needa manually populate a list?

macropod · #4 01-27-2012, 01:31 AM

If you're using late binding (eg when driving Word from Excel and you want compatability with Office versions older than what you're using), you have to use the numeric values. The text versions are only of any use for macros within Word or that use early binding.

tinfanide · #5 01-27-2012, 01:41 AM

Yes, your old thread told me so. It seems that my coming projects are only to be dependent on numeric values.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Debug for macro run through button only when sheet protected	leahca	Excel Programming	0	11-24-2011 04:47 AM
Equations - Enumeration and cross referencing	hpon	Word	5	12-27-2010 02:27 PM
Headers - Enumeration	hpon	Word	1	11-02-2010 10:50 AM
Print preview and actual print do not match?	anthrax19888	Word	1	10-12-2009 08:09 AM
Microsoft Office 2003 winword.exe Debug Error! abnormal prog	elo1bev	Word	0	12-22-2005 10:15 AM