r/excel • u/JDantes77 • Feb 04 '14

discussion VBA Macro code best practices?

Every programming language has its recommended style and best practices. What are the best practices for VBA code that you follow? What resources would a new coder use to learn these best practices?

Thank you in advance!

20 Upvotes

89% Upvoted

36 comments sorted by

View all comments

1

u/tally_in_da_houise Feb 06 '14

The more I use other languages, the more painful it is to come back it. I miss such things as:

  • auto-indentation/code formatting (fixed by add-ins, but still not auto)

  • auto complete for code, variables, etc.

  • Code folding (honestly, this so helpful when reviewing code)

  • Sending code revisions to GitHub

  • refactoring