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.
- Microsoft Office Excel 2007 Visual Basic for Applications Step by Step; Reed Jacobson ; 384 pages; Microsoft Press; ISBN: 978-073562402; $29.99
John’s Power Programming book covers all the basics, and well beyond. It might be overwhelming for someone with absolutely no programming experience though.
- Excel 2007 Power Programming with VBA; John Walkenbach; 1056 pages; Wiley; ISBN: 978-0470044018; 2007; $49.99
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 ; $49.99
- Excel 2007 VBA Programmer’s Reference; John Green, Stephen Bullen, Rob Bovey, Michael Alexander; 1176 pages; Wrox Press Inc; 2007; ISBN 978-0470046432; US$39.99
What Would You Recommend?
If there are other books you’d recommend for a beginner, please add them in the comments.