Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting a collection in a class
I have a class (Task) with a collection property (SubTask) (which is a
collection of another class). I have my Let statement as below, but when I try to make the call to set the property with a collection, I get an invalid use of property error upon compiling. Anyone know what I am doing wrong? Thanks. 'This line doesn't work in a separate method Set Task.SubTasks = colTasks 'Class Property Private pSubtask As New Collection 'let statement Property Let SubTasks(S As Collection) Set pSubtask = S End Property -- ********************* J Streger MS Office Master 2000 ed. MS Project White Belt 2003 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting a collection in a class
Roedd <<J Streger wedi ysgrifennu:
I have a class (Task) with a collection property (SubTask) (which is a collection of another class). I have my Let statement as below, but when I try to make the call to set the property with a collection, I get an invalid use of property error upon compiling. Anyone know what I am doing wrong? Thanks. 'This line doesn't work in a separate method Set Task.SubTasks = colTasks 'Class Property Private pSubtask As New Collection 'let statement Property Let SubTasks(S As Collection) Set pSubtask = S End Property Property Let SubTasks should be Property Set SubTasks -- Rob "We live in a decaying age. Young people no longer respect their parents. They are rude and impatient. They frequently inhabit taverns and have no self control". (Inscription, 6,000 year-old Egyptian tomb) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting a collection in a class
J,
Use Set instead of Let Property Set SubTasks(S As Collection) Set pSubtask = S End Property -- Hope that helps. Vergel Adriano "J Streger" wrote: I have a class (Task) with a collection property (SubTask) (which is a collection of another class). I have my Let statement as below, but when I try to make the call to set the property with a collection, I get an invalid use of property error upon compiling. Anyone know what I am doing wrong? Thanks. 'This line doesn't work in a separate method Set Task.SubTasks = colTasks 'Class Property Private pSubtask As New Collection 'let statement Property Let SubTasks(S As Collection) Set pSubtask = S End Property -- ********************* J Streger MS Office Master 2000 ed. MS Project White Belt 2003 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting a collection in a class
*smacks forehead*
Thank you...*puts on his stupid sign* -- ********************* J Streger MS Office Master 2000 ed. MS Project White Belt 2003 "J Streger" wrote: I have a class (Task) with a collection property (SubTask) (which is a collection of another class). I have my Let statement as below, but when I try to make the call to set the property with a collection, I get an invalid use of property error upon compiling. Anyone know what I am doing wrong? Thanks. 'This line doesn't work in a separate method Set Task.SubTasks = colTasks 'Class Property Private pSubtask As New Collection 'let statement Property Let SubTasks(S As Collection) Set pSubtask = S End Property -- ********************* J Streger MS Office Master 2000 ed. MS Project White Belt 2003 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Wrapping a Collection Class | Excel Programming | |||
Need Class Collection advice | Excel Programming | |||
Collection Class problems | Excel Programming | |||
RaiseEvent from a class contained in a 2nd class collection? | Excel Programming | |||
For/Each iteration for collection class | Excel Programming |