Property Let / Get Statements
 

Is it possible to store arrays in property prpcedures? Specifically -
array's of unknown size?

I tried using ParamArray, but it won't compile (even though MS Help says you
can use it):
-----------------------------------------------------------------------------
Public Property Let FileNames(ParamArray vNewValue() As Variant)
....
End Property
-----------------------------------------------------------------------------
I also tried:
Public Property Let FileNames(ByRef vNewValue() As Variant)
....
End Property

John

Property Let / Get Statements
 

With ParamArray, you would have to list each and every one of the elements of
the array in your assignment statement, i.e. something like this:

FileNames = "Text1", "Text2", "Text3"

In looking at the data types which can be used with Property Let, I don't see
arrays mentioned. But I expect it will work if you store your array in a
variant or user-defined type. That said, I couldn't get it to work with a UDT,
but the variant worked.

On Tue, 19 Oct 2004 08:35:02 -0700, "John"
wrote:

Is it possible to store arrays in property prpcedures? Specifically -
array's of unknown size?

I tried using ParamArray, but it won't compile (even though MS Help says you
can use it):
-----------------------------------------------------------------------------
Public Property Let FileNames(ParamArray vNewValue() As Variant)
...
End Property
-----------------------------------------------------------------------------
I also tried:
Public Property Let FileNames(ByRef vNewValue() As Variant)
...
End Property

John