Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.The grand dame of hotels is not only a destination for afternoon tea, but a trusted stalwart for refined dim sum. ' MyArray is a dynamic array of variants. ' BirthDay is an array of dates with indexes from 1 to 10. ' MyMatrix is a three-dimensional array of doubles with explicitĭim MyMatrix(1 To 5, 4 To 9, 3 To 5)As Double ' Matrix is a two-dimensional array of integers. ' 0 thru 50, assuming Option Base is set to 0 (default) for ' DayArray is an array of Variants with 51 elements indexed, from AnotherVar is of type Variantĭim AnotherVar, Choice As Boolean, BirthDate As Date ' Multiple declarations on a single line. ' Explicitly declare a variable of type Integer. ' AnyValue and MyValue are declared as Variant by default with values The default lower bound for array subscripts is 0 and can be overridden at the module level by using the Option Base statement. It also shows the Dim statement used to declare arrays. This example shows the Dim statement used to declare variables. When you use the Dim statement in a procedure, you generally put the Dim statement at the beginning of the procedure. Each element of a user-defined type variable is initialized as if it were a separate variable. Variant variables are initialized to Empty.

When variables are initialized, a numeric variable is initialized to 0, a variable-length string is initialized to a zero-length string (''), and a fixed-length string is filled with zeros. If you don't specify a data type or object type, and there is no Def_type_ statement in the module, the variable is Variant by default. If you try to redeclare a dimension for an array variable whose size was explicitly specified in a Private, Public, or Dim statement, an error occurs. After declaring a dynamic array, use the ReDim statement within a procedure to define the number of dimensions and elements in the array. You can also use the Dim statement with empty parentheses to declare a dynamic array. Until it is assigned an object, the declared object variable has the special value Nothing, which indicates that it doesn't refer to any particular instance of an object. If the New keyword is not used when declaring an object variable, the variable that refers to the object must be assigned an existing object by using the Set statement before it can be used. The following declares a variable for a new instance of a worksheet. Dim NumberOfEmployees As IntegerĪlso use a Dim statement to declare the object type of a variable. For example, the following statement declares a variable as an Integer. Use the Dim statement at the module or procedure level to declare the data type of a variable. At the procedure level, variables are available only within the procedure. Variables declared with Dim at the module level are available to all procedures within the module. Use a separate As type clause for each variable you declare. Data type of the variable may be Byte, Boolean, Integer, Long, Currency, Single, Double, Decimal (not currently supported), Date, String (for variable-length strings), String length (for fixed-length strings), Object, Variant, a user-defined type, or an object type. The New keyword can't be used to declare variables of any intrinsic data type or to declare instances of dependent objects, and it can't be used with WithEvents. If you use New when declaring the object variable, a new instance of the object is created on first reference to it, so you don't have to use the Set statement to assign the object reference. Keyword that enables implicit creation of an object. The lower bound is zero if no Option Base statement is present. When not explicitly stated in lower, the lower bound of an array is controlled by the Option Base statement. The subscripts argument uses the following syntax: upper upper ]. Dimensions of an array variable up to 60 multiple dimensions may be declared. Name of the variable follows standard variable naming conventions. You can declare as many individual variables as you like by using WithEvents, but you can't create arrays with WithEvents. WithEvents is valid only in class modules. Keyword that specifies that varname is an object variable used to respond to events triggered by an ActiveX object. The Dim statement syntax has these parts: Part

Syntaxĭim varname ) ] type ] varname ) ] type ]]. Declares variables and allocates storage space.

Dim sum chart