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!
VBA Codes
- Thread starter gnanas
- Start date
SteveBausch
Technical User
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.
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
Programmer
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
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
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?)
I find commands/procedures/methods are all treated as separate entities in Help (this is an oxymoron in MSpeak?)
- Thread starter
- #5
- Status
Similar threads
- Locked
- Question