Where's the !@#$%^&*() manual?

  • Thread starter Thread starter Erv Young
  • Start date Start date
E

Erv Young

I'd like to do some serious RTFM on VBA for Excel. I'm stymied at
Step 1, namely, laying hands on a copy of the FM. Where can I get
documentation for the standard Excel objects and their properties,
events, and methods?

Thanks!

--Erv
 
Hi,

The VBA help files are not installed by default, so you'll
have to run Office setup using the Add/remove features
option.
Somewhere at the bottom of all options you'll find a tab
called Office tools, which includes an item called Visual
Basic Help.
Make sure it is set to "Run from MyComputer".

Regards,

Jan Karel Pieterse
Excel TA/MVP
 
I've used a regular VB book and then just pressed F2 to view the object in
Excel. Works just fine for me. You'll just have to go through the API
yourself. Also another great trick is to record a macro of what you want to
accomplish and then view the code that was generated. Clean it up, and make
it useful!

-akshay
 
http://support.microsoft.com/support/excel/content/vba101/default.asp
Microsoft Excel for Windows -- Visual Basic for Applications 101

David McRitchie has some links to tutorial at his site:

http://www.mvps.org/dmcritchie/excel/excel.htm#tutorials

the VBA tutorials are below the general excel tutorials.

Using the format

http://support.microsoft.com/?ID=159619

you can look at some of these articles.

159619 XL97: Sample Macros for Customizing Menus and Submenus

161215 XL97: How to Programmatically Create a Collection

120198 XL: How to Select Cells/Ranges Using Visual Basic Procedures

141691 XL: Visual Basic Example Using If and Case Statements

146055 XL: Using Visual Basic to Create a Chart Using a Dynamic Range

141762 XL: How to Use Looping Structures in Visual Basic for Applications

143345 XL: Visual Basic Macro to Determine Which Button was Selected
 
If you want a book, I recommend John Walkenbach's "Excel <year> Power
Programming with VBA."
 
Back
Top