VBA Initialise/Initialize String/Number Array (not variant)

Initializing String Array in VBA

To initialize a string array in VBA, you can use the following code:

Dim myArray(2) As String
myArray(0) = "First"
myArray(1) = "Second"
myArray(2) = "Third"

This code initializes a string array named myArray with three elements and assigns values to each element.

Initializing Number Array in VBA

To initialize a number array in VBA, you can use the following code:

Dim myNumArray(2) As Integer
myNumArray(0) = 1
myNumArray(1) = 2
myNumArray(2) = 3

This code initializes a number array named myNumArray with three elements and assigns values to each element