What Excel VBA Books Do You Recommend

Maybe you can help. I got an email this week from an Excel 2007 user who wants book recommendations:

“I have a question about Excel Visual Basic. My purpose is to write my own Excel formula. Where or what book do you think I could learn from? I have no prior knowledge of programming.”

Step By Step Books

I like the Step by Step books for a good intro to a topic, although I haven’t read the Excel 2007 version.

Power Programming

John’s Power Programming book covers all the basics, and well beyond. It might be overwhelming for someone with absolutely no programming experience though.

Advanced Programming Books

The following books are excellent resources, but for intermediate to advanced programmers, not beginners.

  • Professional Excel Development; Stephen Bullen, Rob Bovey, John Green; Addison-Wesley Professional; ISBN:0321262506
  • Excel 2007 VBA Programmer’s Reference; John Green, Stephen Bullen, Rob Bovey, Michael Alexander; 1176 pages; Wrox Press Inc; 2007; ISBN 978-0470046432

What Would You Recommend?

If there are other books you’d recommend for a beginner, please add them in the comments.
Thanks!