VBA Codes

[gnanas]

I have started usuing VBA for excel applications. I am confused about some of the terminology used in VBA. Where can I find the full list of Codes used in VBA

 

[SteveBausch]

The Help files are in there, but they can be hard to find. Here's a short list of the VBA Help files:

vbdef98.chm VB definitions
vbcmn98.chm ActiveX reference
veednf98.chm VB editor help
VBAAC10.CHM I think this one is the VB language reference


If you are having trouble getting Help to spit-up the information, you can always do a Search on VB*.CHM , that will yield most of the help files. You can create a folder of shortcuts, change the names, and use them when you have trouble finding exactly what you need.

 

[Nikita6003]

Hiya gnagas

Try the object browser as well - it's an overview of all objects & their properties, methods and events that you can use within the version of Excel VBA you're using. Mighty useful to figure out which code to use when & what for.
But stick to the help files for details & examples - oh, and beware if you're using older XL versions - the VBA help tends to be a bit iffy here and there (typos, wrong constants etc.)

Cheers!
Nikki

 

[Cresby]

I find the object browser somehow unfriendly and confusing (or did to start with) and downright unhelpful for properties. To get round this I often put object names in the watch window (using words from the Object Browser) and running a macro to a breakpoint. If the object has any meaning it will (on break) show a "+" in a box and clicking on the + reveals all the properties I can use. Some are re-entrant and look like the original or the one above two levels up but some contain data that that explains it's function (if the name is not self-explanatory). Having a list of all commands/procedures/methods is the same methodology. ie "That looks promising lets see what it does" school of engineering.

I find commands/procedures/methods are all treated as separate entities in Help (this is an oxymoron in MSpeak?)

 

[gnanas]

stevebausch
nikita6003
cresby
Thanks for your help. I hope I can build on your advise