i-nth logo
VBA best practices that I'll never do
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 and Exit Do in loops.
  • Use named parameters.

Full article: VBA best practices that I'll never do