Vba Book Suggestion

[sjboyd]

I am somewhat new to VBA. I have culled some information here and there from this forum. It has given me a general beginning understanding of a few vba functions. However, I would like to purchase a VBA book that can possibly do 2 things:

1) Walk me through step-by-step how to use and implement some common and helpful VBA functions. (I am a quick learner, so it doesn't have to be too basic, but not too advanced in that it doesn't actually tell me how to implement anything).

2) Serve well as a reference book (not just a tutorial).

Anyone have any suggestions?

[darkyam]

I've been going through Excel 2007 Power Programming with VBA by John Walkenbach. It starts out with the basics of VBA, but covers a lot of ground. It also has several appendices at the back that make a good reference and a CD with workbooks showing the code in the book at work. There's a version for Excel 2003 as well.

[Derk]

I agree that Walkenbach books mentioned by darkyam are excellent intermediate books to learn VBA and the appropriate one should serve both your purposes.

[StephenR]

If you want another recommendation I've used "Excel 2002 VBA: Programmers Reference" and found it useful. I think there are various versions. Can't remember the authors' names apart from a Mr Bullen.

[sjboyd]

Great, thanks guys!

And just for clarification, most of these lines of books should have one relevant for Excel 2003 (which is what I'm using), correct?

[darkyam]

Both the book I suggested and StephenR's have a 2003 version.

[RichardSchollar]

But don't buy the xl2003 VBA Programmer's Reference as Bullen, Bovey and Green (those behind the 2002 version) weren't involved in the production of the 2003 version (and it's consequently nowhere near as good). All the xl2002 stuff will apply to xl2003, so you won't be losing anything (much) by going for the 2002 version.

I personally think the Walkenbach book is better for a beginner though

[pinas]

I agree,I have the Walkenbach book and it is even understandable for me,being a newb.

edit,Just saw this thread is from more than 2 years ago :P ,doesn't make the book less good ofc.