Coding best practices using VBA for Excel

Coding best practices using VBA for Excel
3 November 2013

As developers we all try our best to follow some modicum of best practices when it comes to our coding.

I want to share some of the best practices I now use when writing and developing VBA for Excel:

  • Preparing the Visual Basic Editor.
  • Preparing the code modules.
  • Variable naming conventions.
  • Using comments.
  • Additional code module formatting.
  • Using defined names.
  • Using other peoples code.