Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IF Statements (Mutliple Statements) | Excel Worksheet Functions | |||
Runtime error 380: Could not set the List property. invalid property value of listbox | Excel Programming | |||
Is there a Filename property in PrintOut property | Excel Programming | |||
xls property | Excel Programming | |||
Property Set | Excel Programming |