Vba declaring assigning variable datatype in Excel

Variables are named memory locations in computer that stores a value of a specific data type

Variables can be of any data type such as Text,Number,Decimal,Charater or Object.

Variables should be "Declared" and "Assigned" to use it in the script.

Variables are declared using DIM keyword and assigned values using =

Declaring Variables using DIM keyword

  1. Sub HelloWorld()
  2. Dim variable As Integer
  3. Dim str As String
  4. Dim dbl As Double
  5. Dim obj As Object
  6. Dim flag as Boolean
  7. End Sub

Here is how it looks in the editor

excel vba declaring assigning variable datatype

Assigning Values to the variables

excel vba declaring assigning variable datatype

Here, the variable str holds a value of "Hello VBA", dbl holds "98.87" and variable holds "10"

These values can be accessed anywhere within the script and can be modified anytime

 

You can find similar Excel Questions and Answer hereunder

1) How can I hide a specific Shape in my WorkSheet?

2) How can I prevent other users from adding or deleting Sheets in file?

3) How to use the scenario manager in Excel

4) What is variable scope in VBA, how do variable can be reach from other function or routines in VBA

5) How can I shade alternate rows in color using VBA to make it easier to read voluminous data running into hundreds of rows?

6) How can I turn off Alerts using VBA?

7) One of my formulas has returned an error - how can I trace the error to fix it?

8) I am not able to use VLOOKUP as the lookup value column is to the right of the column that has the information I need. Is there an alternative option?

9) What is variable scope in VBA, how do variable can be reach from other function or routines in VBA

10) How to use the name manager in Excel to have a good overview of the various variables and their names in Excel

 

Here the previous and next chapter