Using Collections 1

[MrMoocow]

Hello,
1)I've tried many things to get collections to work. I've tried just Dim Bob as new collection and many other things. But when ever i go to add an item to the collection i get various error messages. Please can some one give me an example of a collection.

Brad,
Hey! email me any time! Bradsvb@yahoo.com

 

[JohnYingling]

Private Sub Command1_Click()
Dim b As Collection
Set b = New Collection
b.Add Me, Me.Name
MsgBox b(Me.Name).Name
End Sub

Did you forget to do "As New" or "Set ... As New"

http://www.VBCompare.com

Compare Code (Text)

http://www.VBSortGen.com

Generate Sort in VB or VBScript

 

[MrMoocow]

Forgot the "Set", *hits head on desk over and over again...". THanks. Brad,
Hey! email me any time! Bradsvb@yahoo.com

 

[MrMoocow]

Forgot the "Set", *hits head on desk over and over again...". Thanks.
Brad,
Hey! email me any time! Bradsvb@yahoo.com

 

[MrMoocow]

Oooops! Double post, anyway. How do i use the remove command.

It accepts one parameter of Index, but what index? I've tried just a straigh numerical value and many other things but I'm gettign errors.


Thanks again. Brad,
Hey! email me any time! Bradsvb@yahoo.com

 

[MrMoocow]

LOL

Sorry^1024,
Fixed it myself. Brad,
Hey! email me any time! Bradsvb@yahoo.com