Populating a Fixed Array

Once the array has been declared it can be populated.

Dim myArray(3) As Long 
myArray(0) = 50
myArray(1) = 100
myArray(2) = 150
myArray(3) = 200

Using Array Function

The Array function can be used to create an array from an explicit list of constants.
If you want to use the Array function to declare a fixed array then you must declare the array as a Variant.
When the Array function is used, the variables have the variant data type.

Dim arValues As Variant 
arValues = Array(50, 100, 150, 200)

© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited TopPrevNext