Macros in Excel : Learn Excel VBA : Objects
Macros in Excel : Learn Excel VBA : Methods
Macros in Excel : Learn Excel VBA : Properties
It is not necessary to declare a variable in VBA, Visual Basic automatically creates storage for a variable on first use in the code. Automatically created variables are of type variant and can contain any type of data. It can be strings, boolean values, object , arrays or numbers.
Simple statement such as given below creates a variable and assigns value to it
Myvariable = 28
Similarly you can use different variables in calculation to create another variable for your VBA code. Following code will explain the use of Variables in Excel VBA
Var_A = 10
Range("A4").Select ' Value of Cell A4 is 5
Var_B = ActiveCell
Var_Total = Var_A + Var_B
Range("A5") = Var_Total
This code explains that
1. Var_A is declared as constant number in the code itself.
2. Var_B is declared as value in ActiveCell i.e. Cell A4 in this case with Value as number 5.
3. We have used Var_A and Var_B to calculated Var_Total
4. We have used Var_Total to update the value in Cell A5, the result of this code is number 15 in Cell A5