My Favorite Excel VBA References

Here are some references I’ve found particularly useful when developing or debugging SQL code.  When trying something new, I like to have a user’s guide open at my left elbow, a language reference guide open at my right elbow, and a steaming cup  above the keyboard.  (With Excel VBA, that cup usually needs to be a soothing cup of tea instead of the usual jolt of coffee.)  When debugging, I like to have a debugger reference on the left, and a large unloaded revolver at my right.  (The bugs find the revolver intimidating, and I find that snapping sound more rewarding than admitting my programming errors.)

Framework

To effectively learn a new programming language, I like having a well-organized written framework that guides my perspective on the structure and use of that language.  Here are a couple of on-line documents that provide that kind of framework.

http://www.excel-spreadsheet.com/vba/vba.htm

http://analystcave.com/vba-cheat-sheet/

VBA User’s Guides

These focus on techniques for using specific methods.  They are generally stronger than beginner’s introductions.

http://analystcave.com/vba-cheat-sheet/

https://excelmacromastery.com/

VBA Reference Guides

These provide encyclopedic reference on the details of function and syntax.

https://msdn.microsoft.com/en-us/library/office/ee861528.aspx

https://msdn.microsoft.com/en-us/library/office/ff820756.aspx

https://msdn.microsoft.com/en-us/library/office/ff194068.aspx

https://msdn.microsoft.com/en-us/library/office/gg264383.aspx

http://www.excel-spreadsheet.com/vba/vba.htm

http://www.dummies.com/software/microsoft-office/excel/common-vba-statements-for-excel-vba-programming/

VBA Style Guides

These provide some best practices on structuring the code.  (I’m embracing the new standard of abandoning Hungarian notation in lieu of more descriptive naming.)

https://msdn.microsoft.com/en-us/library/aa240822(v=vs.60).aspx

http://docs.chejunkie.com/vba-coding-standards-and-guidelines/

http://www.fmsinc.com/tpapers/vbacode/

https://github.com/danwagnerco/vba-style-guide

VBA Cookbooks

http://pythonexcels.com/python-excel-mini-cookbook/

https://powerspreadsheets.com/

http://www.excel-easy.com/examples.html#vba

VBA Tutorials

The better organized on-line tutorials easily serve as user’s guides.

https://www.tutorialspoint.com/vba/

http://www.excel-easy.com/vba.html

http://www.excelfunctions.net/Excel-VBA-Tutorial.html

http://excelvbatutor.com/vba_tutorial.html


(Image courtesy of the3cats at Pixabay.)

Advertisements

One thought on “My Favorite Excel VBA References

  1. Pingback: What Makes Excel VBA Special? | Carl Gusler

Comments are closed.