Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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) |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
*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 | |
|
|
![]() |
||||
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 |