View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Vergel Adriano Vergel Adriano is offline
external usenet poster
 
Posts: 857
Default 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