Show List
Tutorials > VBA > Variables and data types

Variables and data types

In VBA, variables are used to store and manipulate data. A variable is a named memory location that can hold a value, which can be a number, text, or any other type of data.

There are different data types in VBA, including:

  • Integer: stores whole numbers within the range of -32,768 to 32,767
  • Long: stores whole numbers within the range of -2,147,483,648 to 2,147,483,647
  • Single: stores decimal numbers with single precision
  • Double: stores decimal numbers with double precision
  • String: stores text
  • Boolean: stores logical values, True or False

To declare a variable in VBA, you need to specify its data type and name. Here's an example of declaring and using a variable in VBA:

vbnet
Copy code
Sub Example()
   Dim myNumber As Integer 'declaring an integer variable
   myNumber = 10 'assigning a value to the variable
   MsgBox "The value of myNumber is " & myNumber 'displaying the value in a message box
End Sub

In the above example, we declared an integer variable called myNumber and assigned a value of 10 to it. Then, we used the MsgBox function to display the value of the variable in a message box.

Here are some examples of declaring variables with different data types in VBA:

vbnet
Copy code
Sub Example()
   Dim myInteger As Integer 'integer variable
   Dim myLong As Long 'long variable
   Dim mySingle As Single 'single variable
   Dim myDouble As Double 'double variable
   Dim myString As String 'string variable
   Dim myBoolean As Boolean 'boolean variable
End Sub

You can also assign values to variables directly when declaring them:

vbnet
Copy code
Sub Example()
   Dim myInteger As Integer
   myInteger = 10 'assigning a value to the variable when declaring it
End Sub

In summary, variables in VBA are used to store and manipulate data. They can hold different data types, such as integers, strings, and booleans. To declare a variable, you need to specify its data type and name. You can assign values to variables directly or separately.



Next: Operators and expressions

    Leave a Comment

  • captcha text