Books and Guides

Find below the list of books, guides, and other materials to learn Excel VBA recommended in this site (my own books/guides and others from amazon). There are different options depending on the level of proficiency with Excel VBA.

 

I believe learning should start with small steps, otherwise one might get discouraged. For that reason, I have put together a simple guide to get you started with a solid foundation in no time. The Excel VBA Guide for Beginners is just 75 pages long with lots of VBA code examples and illustrations, so it should not take you more than a few days or weeks to read it and understand it. It consists of ten comprehensive chapters covering each of the key areas of Excel VBA, and an appendix section with the description of commonly used Excel VBA objects and the full list of VBA functions.

If you already have a basic knowledge of Excel VBA, or if you have read the guide for beginners above, this is the way to go to get your Excel VBA skills to the next level. The introductory chapter expands on the Excel Object Model and helps understand all about working with objects. The following chapters focus on each of the 10 most important Excel VBA objects. It is a 142 pages to read with an extensive appendix as part of it, including the full list of Excel VBA objects, the properties, methods, and events, for the objects covered in the guide, and the shape and chart types enumerations. 

 

 

Another option for beginners is Excel VBA Programming for Dummies (6th Edition) by Dick Kusleika (previously by the well-known John Walkenbach), which is 432 pages long and has more content and "historical" details that may give you a broader view. I got the 2nd edition about 10 years ago, and helped me understand some key concepts. It covers all the basics, provides many examples, it also covers error-handling and bug extermination extensively, as well as a very good foundation to work with userforms, and even will introduce you to creating Add-Ins.

Check out our puzzle books too!

 

        

For Intermediate to advanced Excel VBA enthusiasts and learners, either of these other two books (Microsoft Excel 2019 VBA and Macros, and Excel 2019 Power Programming with VBA) have great and more extensive content, and have been very well rated on Amazon.

            

Go to the training for beginners