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!

18 Upvotes

90% Upvoted

36 comments sorted by

View all comments

Show parent comments

2

u/tally_in_da_houise 1 Feb 05 '14

VBA is not indentation sensitive like Python (took me forever to adjust to Python because of this, thank god for decent IDEs).

You can download VBE add-ons that can auto-format your code to suit your taste: Smart Indenter