Recipe 2.5. Defining Constants
You'd like to declare some constants and need to know the correct VBA syntax.
VBA constants are declared using the syntax
Example 2-6. Declaring constants
Just as with variables, you can declare constants with local or global scope. Constants declared within procedures have local scope; that is, they are available only within the procedure. Constants declared outside of any procedures at the beginning of a code module have module-level scope and can be used by any procedure within the module. As with
A constant is just that, constant. Once a constant is declared with its value set, you cannot change its value. Constants are useful for defining descriptive
Recipe 2.6. Using Arrays
You don't know the VBA syntax for declaring arrays .
You declare arrays just as you do
Example 2-7. Declaring arrays
Arrays are declared with their size specified in parentheses following the array
When you use the To keyword in an array size specification, the first number is the lower bound and the second number (the one following To ) is the upper bound of the array. You can skip the To keyword and simply put the desired size (i.e., the number of array elements) in parentheses following the array name. In this latter approach, the first array index, the base, is 0 unless you use the Option Base statement.
Use the Option Base statement at the beginning of a code module (before your procedures) to specify the default base for arrays. For example, Option Base 1 sets the base to 1, while Option Base 0 sets the base to 0.
You can declare multidimensional arrays by separating each dimension's size, or upper and lower bounds, by commas in the array declaration, as shown in the last two lines of Example 2-7. VBA supports multidimensional arrays of up to 60 dimensions.
To actually access an array's elements in your code statements, write the array name followed by the index to the array element
Example 2-8. Accessing array elements
Separate the array indices by commas for multidimensional arrays.
The array declarations discussed here are
declarations in that the size of the arrays is specified in the
statement. In some special cases, you may not know the required size of an array and may need to allocate memory for the array dynamically. In such cases you can declare the array as discussed earlier but leave the parentheses following the array name blank (include the parentheses, just don't put anything between them). Then in your code you'll have to dynamically allocate memory for the array of the size you