Creates a local variable or array with the name and size (in the case of an array) and data type specified.


The Var statement has two forms:

Var variableName [, variableNameN ] As [ New ] DataType [ = InitialValue ]





Variable name

The name of the new variable.


Variable name

Optional. The names of other variables you wish to create with the same data type.


Data type or class

The data type or class of the variable being declared.


Same type as DataType

Initial value for variableName.

Var arrayName(ubound [, ubound2, ...uboundN ]) As DataType





Variable name

The name of the new array.



The upper bound of the array. This must be a number or a constant.



Optional. The upper bound of the next dimension of the array if you are creating a multi-dimensional array.


Data type or class

The data type or class of the array.


In the first syntax, the Var statement is used to create new variables. Variable names can be any length but must begin with a letter and can contain only alphanumeric characters (A-Z, a-z, 0-9) or an underscore. A user-defined variable cannot begin with an underscore. You can, however, use Unicode characters in variable names. Variable names are case-insensitive so x and X are considered the same variable.

A variable is an object stored in RAM that can hold a value. In the second syntax, the Var statement is used to create a new array of the size specified. An array is a variable that can contain multiple values that are all the same data type. Passing more than one size parameter creates a multi-dimensional array, with the number of dimensions equal to the number of size parameters passed.

You can optionally provide an initial value to a variable declared with a Var statement. Here are some examples:

Var a As Integer = 5
Var b As Double = 87.87
Var s As String = "Howdy"
Var c As Color = &cFF4B51
Var myAttributes() As Introspection.AttributeInfo = Introspection.GetType(Window1).GetAttributes

The following statement initializes three variables to an initial value:

Var x, y, z As Integer = 10

After the statement, all three variables have the same initial value.

If the data type is an object, you can optionally instantiate the object with the New keyword in the Var statement. This code declares and instantiates a FolderItem object.

Var f As New FolderItem

Otherwise, you need a second line of code to instantiate the variable, d, as in the following:

Var f As FolderItem
f = New FolderItem

If you use the New keyword, then you cannot declare more than one variable in a single Var statement.

If the call to the object's constructor takes parameters, you can pass the parameters as well. Here is an example:

Var mb As New FolderItem("file.txt")

You can use a constant or an enum as an initial value. Suppose you add a global constant, InitialValue=-1, in a module. You than can dimension a variable with the statement:

Var testConstant As Integer = InitialValue

Suppose you add a global enum named "SecurityLevel" in a module with values None, Minimum, Maximum, and Forced. You can then use any of the enums in a declaration statement such as:

Var testEnum As Integer = SecurityLevel.Maximum

The Var statement can be placed anywhere in a method or function, including inside a conditional structure (an If or Select Case statement).

Variables created with the Var statement are local in scope. This means that they are created each time the method is called and are destroyed when the method is finished. The value of a local variable can be accessed only from within the method.


Arrays are created by specifying the upper bound. All arrays are indexed starting at position 0. Arrays can have a maximum index value of 2,147,483,646 (this is the maximum for both 32-bit and 64-bit apps).

This code creates an array with 5 elements:

Var aNames(4) As String

Array indices start at 0, so the above array can contain values in index 0, 1, 2, 3 and 4:

aNames(0) = "Bob"
aNames(2) = "Tom"

If you don't know the upper bound of the array you need at the time you declare it, you can declare it as an empty array, i.e., an array with no elements, and use the ResizeTo command to resize it later. You do this by giving it an index of -1 or by leaving the parentheses empty. This means "an array of no elements." For example, the statement:

Var aNames (-1) As String

creates the array aNames with no elements. If your program needs to load a list of names that the user enters, you can wait to size the array until you know how many names the user has entered. You can also accomplish this by leaving out the -1. The following statement is equivalent:

Var aNames() As String

You can also use a constant to specify the array size:

Const size = 3
Var aNames(size)

When you assign values to an array variable, such as with the String function, you don't need to know the number of elements ahead of time.

You can also assign an array to another array. For example, the following is valid:

Var myArray(3) As String
Var newArray() As String
myArray(0) = "Anthony"
myArray(1) = "Aardvark"
myArray(2) = "Accountant"
newArray() = myArray ' newArray set equal to myArray

Note that when you do this you do not have two separate arrays. Both myArray and newArray refer to the same data, so modifying one also modifies the other.

Multi-dimensional arrays

Multi-dimensional arrays require some special treatment, and most of the usual array functions are not supported.

To create a 2D array:

Var my2Darray(-1, -1) As String

You cannot Var a multidimensional array with a variable, but you can do the following:

Var numberOfRows As Integer = someOtherArray.LastIndex
Var my2Darray(-1, -1) As String
my2Darray.ResizeTo(NumberOfRows, 9)

To pass a multi-dimensional array to a method you use the following in the method declaration:

Sub MyMethod(param(,) As String)

Var vs. static

The Static statement provides an alternative to Var. Static creates a local variable or local array with the name and size (in the case of an array) and data type specified. A variable declared with the Static statement and assigned a value retains its value from one invocation of the method to the next. In contrast, variables declared with the Var statement are completely local to the method and are destroyed when each invocation of the method goes out of scope.

Sample code

This example uses the Var statement to create an integer variable called "age" and assigns it the value 33.

Var age As Integer
age = 33

This example uses the Var statement to create two String variables.

Var FirstName, LastName As String

This example uses the Var statement to create an array called aNames with 11 elements (remember, arrays have a zero element).

Var aNames(10) As String

This example uses the Var statement to create an array called aNames with one element.

Var aNames(0) As String

This example uses the Var statement to create a two-dimensional array called aNames with 11 rows and 4 columns.

Var aNames(10, 3) As String


All project types on all supported operating systems.

See also

Arrays command; VarType method; Arrays.LastIndex function; Dictionary class; Arrays concept; Static statement; A Var Statement creates only one new object at a time error.