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

-----Original Message-----
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
.

If you can't find what you're looking for in the help file, you might check
Amazon.

Dave

"Erv Young" wrote in message
om...
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,
I find the object browser useful. Press F2 while in
VBA.
-----Original Message-----
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
.

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

"Erv Young" wrote in message
om...
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

http://support.microsoft.com/support...01/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....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

--
Regards,
Tom Ogilvy


"Erv Young" wrote in message
om...
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

If you want a book, I recommend John Walkenbach's "Excel <year Power
Programming with VBA."

"Tom Ogilvy" wrote in message
...
http://support.microsoft.com/support...01/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....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

--
Regards,
Tom Ogilvy


"Erv Young" wrote in message
om...
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