4 Mistakes You Can Avoid when Programming Excel Macros with VBA

Make sure the checkbox is enabled, and now the Developer tab will appear in your Excel menu.


The easiest way to get into the code editor window at this point is just to click on the View Code button under Controls in the Developer menu.

1. Horrible Variable Names

Now that you’re in the code window, it’s time to start writing VBA code. The first important step in most programs, whether it’s in VBA or any other language, is defining your variables.

Throughout my couple of decades of code writing, I came across many schools of thought when it comes to variable naming conventions and learned a few things the hard way. Here are the fast tips for creating variable names:

Prev2 of 9Next

Leave a Reply

Your email address will not be published. Required fields are marked *