3 July 2013
I don't know if these are really "best practices" or if I'm just making them up. I know I heard them somewhere, but that doesn't make them universal by any means. Also, I generally agree with all of these best practices, although I have no intention of changing my ways:
- Never use lowercase 'i' or lowercase 'l' as variables.
- Don't reuse variables.
- Align data types in
Dim
statements. - Declare each variable on its own line.
- Comment, comment, comment.
- Avoid
Exit For
andExit Do
in loops. - Use named parameters.
Full article: VBA best practices that I'll never do