reference for vb_______ constants?
Once again I can't figure out how to look something up effectively...
I have found this minimal list that contains vbLf, vbNullString, and such...
http://msdn.microsoft.com/en-us/libr...(v=VS.80).aspx
But what about things such as "vbArray" and "vbVarType", etc.?? I see they are related after looking up vbArray in the object browser- then playing with the immediate window, etc. to figure out what it is...I think... but where is a reference for these constants? And to add to my confusion, on the MSDN site every single "constant" (under "enumerations") starts with "xl" not "vb".
What's up with this aspect of the language? Seems like there are probably a ton of them and a list would be handy to have... any tips on this? Thanks!
Re: reference for vb_______ constants?
xl constants are specific to excel objects
most, but not all, vb constants are valid in vba
each office application has constants specific to its own objects, generally prefixed with indication of application (xl, wd etc)