I C++ kunde man göra en array med en variabel ex. test[20], vad finns det för motsvarande funktion i VB?

Statisk dimensionering:
Dim Test(1 To 20) As String

Dynamisk dimensionering:
Dim Test() As String
ReDim Test(1 To 10)
ReDim Preserve Test(1 To 20) 'Om man vill spara befintilig värden

Kontrolera lägre och övre gräns:
Dim Index As Long
For Index = LBound(Test) To UBound(Test)
Debug.Print Test(Index)
Next

Flera dimensioner
Dim Test(1 to 20, 1 to 20) As String
Dim X as Long
Dim Y as Long

For Y = LBound(Test, 2) To UBound(Test, 2)
For X = LBound(Test, 1) To UBound(Test, 1)
Debug.Print Test(X,Y)
Next
Next

Ett utdrag ur referensen VB..

Array Function

Returns aVariant containing anarray.

Syntax

Array(arglist)

The required arglistargument is a comma-delimited list of values that are assigned to the elements of the array contained within the Variant. If no arguments are specified, an array of zero length is created.

Remarks

The notation used to refer to an element of an array consists of thevariable name followed by parentheses containing an index number indicating the desired element. In the following example, the firststatement creates a variable named A as a Variant. The second statement assigns an array to variable A. The last statement assigns the value contained in the second array element to another variable.

Dim A As Variant
A = Array(10,20,30)
B = A(2)

The lower bound of an array created using the Array function is determined by the lower bound specified with the Option Base statement, unless Array is qualified with the name of the type library (for example VBA.Array). If qualified with the type-library name, Array is unaffected by Option Base.

Note A Variant that is not declared as an array can still contain an array. A Variant variable can contain an array of any type, except fixed-length strings anduser-defined types. Although a Variant containing an array is conceptually different from an array whose elements are of type Variant, the array elements are accessed in the same way.