This is my list of the best VBA programming and Excel Formula books. All of these are on my bookshelf.

These books will teach you:

  • basic code to use as templates for future projects
  • how to structure your routines to avoid spaghetti code, common coding errors
  • ideas for ways to automate complex tasks


Buy these books today, you will not be disappointed.

VBA Reference Materials

If you have Office 2003, there are standalone help files for Word, Excel, Access and Outlook VBA Object Models. These are an excellent 'desktop' reference when you are coding.