VBA Commands

[WLMPilot]

Can anyone recommend a good website and/or book that has all or most of the
VBA commands along with how to use them, that can be used in Excel and
Access.

Thanks,
Les

 

[Alok Joshi]

I have found books by Mr. Walkenbach extremely good - he has written Excel
Bible books if you are mainly interested in the GUI, Formula books to learn
explicitly and in detail about the formulas and books on Developing within
excel. The best web site is one by Chip Pearson.

Also be clear if you want to learn about VBA or about Excel Object model.
These are two very different things. You need to master both to become an
expert in developing Excel based applications.

Alok

 

[ilia]

Can anyone recommend a good website and/or book that has all or most of the
VBA commands along with how to use them, that can be used in Excel and
Access.

Thanks,
Les

I would additionally recommend Excel 200x VBA reference, appropriate
for your version. Besides having a complete list of Office, Excel,
and VBA object reference, it includes numerous chapters on how to
actually use them. Extremely useful.

The Walkenbach book does explain more techniques applied to actual
situations, and many of his advanced examples are useful as well.