So before you purchase a book I encourage you first to open up the VBA Developer tab and start by Recording a few macros. The above mentioned stand in the 20-30s of $ of budget bringing, however, you home into learning how to become proficient in Excel VBA programming.Īs closing notes, remember – learning by doing is the best approach. You might find a lot of alternatives but often getting less value (and often pages/content) for you money. Might be more challenging for beginnersĪlthough there are tons of other Excel VBA books out there I decided to just go for the top 3 from the ones I am familiar with.If you have some experience in VBA (or other languages) go for it, however, consider another read if you want to really understand the basics. The downsides I think are that the book might be harder to comprehend for total beginner programmers.

What I really liked is the amount of images and code examples. Top 6 Excel VBA Macros Books Updated 2023 Excel VBA Macro Programming VBA and Macros for Microsoft Excel (Business Solutions) Office VBA Macros You Can Use. The book is shorter than the previous 2 above although priced similarly. This book is worth reading if you want to quick start yourself into writing Excel VBA macros and automations by jumping right in with ready code examples.

This time coming from Bill Jelen (Mr Excel) who is another familiar persona in the world of Excel, the book VBA and Macros: Microsoft Excel 2010 (MrExcel Library).

Visual basic for excel 2010 book