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. Provides a good introduction to VBA for Excel as well as some continuation. Around 1100 pages.


Excel 2010 Power Programming with VBA (Mr. Spreadsheet's Bookshelf)

Excel 2013 Power Programming with VBA (Mr. Spreadsheet's Bookshelf)

Professional Excel Development

By Bullen. 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 2013 VBA and Macros (MrExcel Library)

Edition 2016