FAQ About Excel Visual Basic for Applications
How do we assign values to variables in Excel?
It's as easy as specifying with an equal sign. For example, let's say you are creating a numeric variable.
- Dim numericVariable As Integer
Let's say you want to give the value 10 to this variable from here on out. When you type it to the code panel this;
- numericVariable = 10
the value 10 will be assigned to your variable.
