Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help passing an array as an argument
Hello all,
I wanted to ask for some quick help. For the life of me I cannot figure out why the following code will not work... Any hints/comments? '''''''''''''''''''''''''''''''''''''''''''''''''' ''''''''''''''''''' 'In a class module written in VB6 I have the following paired property procedure Public Property Get SomeArray( ) As String( ) SomeArray = mstrHiddenArray End Property Public Property Let SomeArray(ByRef TempArray( ) As String) mstrHiddenArray = TempArray End Property '''''''''''''''''''''''''''''''''''''''''''''''''' ''''''''''''''''''' 'Inside an Excel VBA module I call the above property procedu Call MyObject.SomeArray(gstrGlobalArray) 'Note: gstrGlobalArray is a TWO-dimensional string array... '''''''''''''''''''''''''''''''''''''''''''''''''' ''''''''''''''''''' In the Excel VBA module where I invoke the property procedure I get an "Invalid Use of Property" error message... What do you think? Forget programming & get another career??? lol Anyways, anything anybody could contribute would be helpful... Thanks, blc |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Passing a UDF as an argument to a UDF | Excel Discussion (Misc queries) | |||
VBA - Passing a FUNCTION as an Argument | Excel Programming | |||
Passing range as argument | Excel Programming | |||
Passing an Array of User-Defined Type to an Argument of a Function | Excel Programming | |||
Passing an argument to a quote | Excel Programming |