Thread: Unable to add user-defined data types to a collection
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jamie Collins Jamie Collins is offline
external usenet poster
  
Posts: 593
Default Unable to add user-defined data types to a collection
"Peter Beach" wrote ...

You can only add objects to collections

That's not correct:

Sub test2()
Dim c As New Collection
Dim s As String
Set c = New Collection
s = "Text"
c.Add s
End Sub

Jamie.

--
Reply With QuoteReply With Quote