VBA Array of variant type as class property

Question

I have a class that handles several numeric arrays (type double) and also needs to handle an array of descriptors, which will include a mix of strings and integers, which need to be utilized as strings and numbers accordingly. So I decide to make an array property of type variant (not a variant containing an array). But this one does not seem to work, while the type double arrays do.

Specifically, this type double array-property works fine, to receive or return an array all at once:

Private p_dbNumericArray() As Double

Public Property Let NumericArray(Value() As Double)
    p_dbNumericArray() = Value()
End Property
Public Property Get NumericArray() As Double()
    NumericArray() = p_dbNumericArray()
End Property

But when I try the same pattern with an array of type variant, the Get property returns an empty/unallocated variant array:

Private p_vaVariantArray() As Variant

Public Property Let VariantArray(Value() As Variant)
    p_vaVariantArray() = Value()
End Property
Public Property Get VariantArray() As Variant()
    VariantArray() = p_vaVariantArray()
End Property

Wrapping an array in a variant (instead of having an array of type variant), of course works fine:

Private p_vaVariantArray As Variant

Public Property Let VariantArray(Value As Variant)
    p_vaVariantArray = Value
End Property
Public Property Get VariantArray() As Variant
    VariantArray = p_vaVariantArray
End Property

But is it known and standard that the pattern that works for Dim D() As Double does not work for Dim V() As Variant, in properties?

Tomalak · Accepted Answer · 2011-03-17 17:22:56Z

2

Public Property Get VariantArray() As Variant()
    VariantArray = p_vaVariantArray()
End Property

Note the missing parentheses.

answered Mar 17, 2011 at 17:22

Tomalak

340k68 gold badges547 silver badges635 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

RomnieEE2 Over a year ago

Gah--another easy one! Thanks. What about the analogous line for the Double array " NumericArray( ) = p_dbNumericArray( ) ", which seems to work fine with the extra parens? Are they optional here? Or is something subtle going on? Thanks again.

RomnieEE2 Over a year ago

Whoops. Looks like that "NumericArray( ) = ..." actually doesn't work. I lost track of editing too many things at the same time. So those parentheses are just absolutely wrong. Thanks again.

Tomalak Over a year ago

@Romnie: Yes, the parens are always absolutely wrong. They are calling the function, but you actually want to assign to it (i.e. set the return value).

Collectives™ on Stack Overflow

VBA Array of variant type as class property

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related