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.”

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

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

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

What Would You Recommend?

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