Function Array Manipulations Class

SetVariantVector

"Set Variant Vector Element" Sets the value of an element of a one-dimensional Variant array. Will expand the array if necessary to allow the element to be set.

Signature (Visual Basic / VBA)

Public Function SetVariantVector( _
      ByRef rIn() As Variant _
    , ByVal v1Dim As Variant _
    , ByVal vValue As Variant _
    ) As Boolean

Code Examples

    Assuming
       Dim avarData() As Variant
       ReDim avarData(0 To 5)
    for example
       SetVariantVector(10, "RE") = True
    rIn(v1Dim) = vValue

Parameters

Parameter Description
rIn One-dimensional array of Variant values. rIn must already be dimensioned before it is passed to this function or else an error will occur. rIn should be dynamic because this function will attempt to redimension the array if necessary so that the specified element can be set.
vValue The value that will be assigned to element rIn(v1Dim)

Return Value

Function returns True upon success.

Notes & Version History

v1Dim Number of the element whose value will be set to vValue. Function returns False if v1Dim is Null or cannot be fixed-up to a number.