Dim

The Dim statement allocates storage for, and declares the data type of, variables and arrays in a module.

The To clause in the array subscript range of a Dim statement provides a more flexible way to control the lower bound of an array. If you don't explicitly set the lower bound with a To clause, the Option Base setting (if used) comes into affect, or defaults to zero (if not used).

Syntax

Dim VariableName[(Subscripts)] [As DataType]

VariableName:

The name of the variable or array being declared (dimensioned).

Subscripts:

The optional subscript range (dimensions) for an array in parentheses.

DataType:

The optional data type declaration for the variable or array.

Related Functions

Const | ReDim | Static

Example

Dim bytVar As Byte

Dim binVar As Boolean

Dim strVar As String

Dim intVar As Integer

Dim lngVar As Long

Dim sngVar As Single

Dim dblVar As Double

Dim vntVar As Variant 

Dim objVar As Object

Dim dtmVar As Date

Dim daysOfWeek() As String ' declares an array variable to hold strings

Dim monthsOfYear(12) As Date ' declares an array variable to hold 12 strings
Dim users(,) As String ' declares a two dimensional array to hold strings
Dim usernames(5,5) As String ' declares a two dimensional 5 x 5 array to hold strings

Dim MyArray(1 To 10, 5 To 15, 10 To 20) ' declares the three dimensional array
 MyArray and specifies the upper and lower bounds of each dimension