Best Excel VBA macro programming and development books and tutorials

Books can be a useful complement to training to help you learn more about how to program VBA and macros for Excel. Below are listed some of the books recommended by Excelkurs Direkt for further enhancement of VBA macro programming skills. The books are typically available in at least one edition per version of Excel. The largest differences in VBA is found between Excel 2003 and earlier, and Excel 2007 and later.

Excel Power Programming with VBA

Classic by Walkenbach (until 2013 edition), then by Michael Alexander and Dick Kusleika. Provides a good introduction to VBA for Excel as well as some continuation. Around 1100 pages.

Excel 2021 Power Programming with VBA

Professional Excel Development

By Bullen et al. Around 1200 pages, a bit more advanced topics than EPP above.

Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET (2nd Edition)

VBA and Macros: Microsoft Excel

By Jelen, et al. Around 700 pages, more in the style of Excel VBA cookbook recipes.

Excel 2021 VBA and Macros