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
Sub Explain_Variables()
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
End Sub
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
Thanks for writing this quality informational content. It's very helpful for us. I was looking for this information. I encourage you to publish more information about this article. Now it's time to get https://www.vfixphonesandtech.com/ for more information.
ReplyDelete