In the long run it will save you a lot of heartache, just trust me on this one. If you haven’t gathered already, declaring variables is a computer coding best practice! So just get in the habit of doing it. This will serve as a flag that you either messed up your logic or you need to create a separate variable to store that text string.
DIM SUM MEANING CODE
If a variable is set to only store numbers and you accidentally add a line of code that sets that variable equal to a text string, your code will error out. Stops the Wrong Type of Data from Getting Stored. So if I notice that a declared variable that I created did not capitalize after I typed it's name, I know that I must have misspelled it. The Visual Basic Editor will automatically capitalize any word that is stored in its own vocabulary list along with any variable that you have dimensioned. I then will type the body of my code in all lowercase letters. I make it a common practice to have at least one uppercase letter in all of my variables that are longer than three characters. This will allow you to easily keep track of all your variable names and what values they should have. If you make it a common practice to have a declaration section in your code, you essentially are creating a vocabulary list that you can reference while you are coding. Keep Track of Your Variables and Stay Organized.
If you have a bunch of variables scattered throughout you’re subroutines, it helps other Excel Gurus who are looking at your code to comprehend if you are using a variable to read in a number or store a range location. Here are the ones I can think of (please leave a comment if you can think of any other reasons and I will add them to the list):Įasier for Others to Understand Your Code. There are a bunch of reasons why you should use Dim and declare your variables. I'd like to give a special thanks to Bob Phillips for recommending to add this tip to the post via the comment section. Note, that if you are declaring an Array variable you can also set the parameters of the array by writing the following: String – Stores text (must surround text with quotation marks)īoolean – Stores either a True (-1) or False (0) value I will not go into great detail of all the different variable types but I will list some of the ones I most often use: This restricts what kind of data can be stored in the variable. The other part of a dimension statement is spelling out the Variable Type. The variable name can be anything you want as long as it is one word and does not match the name of any VBA function, class, or accessor (so you couldn’t name your variable Worksheet or Sub). Dim is often found at the beginning of macro codes and has the following format:ĭim as
Dim is short for the word Dimension and it allows you to declare variable names and their type.
0 kommentar(er)
