VBA help

[bigk3112]

basic question really... i'm a novice user of excell and want to start using VBA can anyone recommend a good place to learn on the internet

or a good book to buy as a learning guide

Thanks ......

 

[Jonmo1]

Welcome to the board...

Number 1 - This Forum is a GREAT place to learn. Probably learn more here than in any book.

Number 2 - Use the Macro Recorder.

Tools - Macro - Record New Macro.
do the task manually
Tools - Macro - Stop Recording.

Any task you can do manually, use the macro recorder to record yourself doing it manually, then look at the VBA code it created. Great Resource.

 

[Richard Schollar]

If you're just starting out, then in my opinion one of the best learning books is the following by John Walkenbach:

http://www.amazon.com/Excel-Program...5103109?ie=UTF8&s=books&qid=1173369122&sr=8-3