I'm also not a vba guy but you SHOULD be able to do what he said...
That's off the absolute top of my head, but I think that should give an idea anyway.
Type Blah ID as integer Name as string End Type Dim Blahs as new Collection Dim tblah as new blah for t = 1 to 5 tblah.id = t tblah.name = cstr(t) & "Name" Blahs.Add tblah next
That's off the absolute top of my head, but I think that should give an idea anyway.