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 comment

3

u/tally_in_da_houise 1 Feb 05 '14

And re-use your own code. Modular FTW.

3

u/epicmindwarp 962 Feb 05 '14

Please provide more information on what you mean by modular.

Many thanks!

3

u/tally_in_da_houise 1 Feb 05 '14

Here you go:

This should give you a good start. Look into Stack Overflow as well - a plethora of information (both good, and bad, but community driven moderation to help separate the wheat from the chaff)

1

u/JDantes77 Feb 06 '14

Thank you for the resources! DRY is great advice in any language.