Books

[lefty78312]

I'm looking for a book (or books) for an absolute beginner to learn VBA for Excel. I guess I need a hold-my-hand type of book that explains everything one-step-at-a-time and WHY code is written the way it is, because I struggle mightily with syntax, etc., and understanding the <i>why</i> of it all. In other words, what goes where, and when and why.

I understand that the 'Absolute Beginners Guide To VBA' is really not a good book to start with because it presupposes some knowledge of the subject. I'm sort of an advanced Excel beginner on the verge of becoming an intermediate, but since I'm self-teaching, I need something that explains everything one step at a time and gives me examples to practice before moving on to the next step.

Does anyone have any recommendations?

Thank you.

 

[Richard Schollar]

Hi

I'm going to move this post to the General Excel discussion forum, but my recommendation for you (and anyone else in your position) is John Walkenbach's Excel VBA Programming for Dummies:

http://www.amazon.com/Excel-2007-Pr...=sr_1_6?ie=UTF8&s=books&qid=1203362015&sr=8-6

It's a great book for the beginner.

 

[lefty78312]

Thank you. The book you recommended is for Excel 2007, and I'm running Excel 2000. Would 'Excel VBA Programming For Dummies (Computer/Tech)' by John Walkenbach be a good beginners book?

 

[Richard Schollar]

Yes there's a 2000 version. I learned VBA using the xl97 version of this book.