In VB.NET I could do the following:

Public class car

Public property capacity as integer

end property

End class
and then in the code I could instantiate it as:


Dim C as new car

dim vehicles as new list(of car)

c.capacity = 10

vehicles.add(c)

for each car in vehicles

msgbox(car.capacity)

next car

I want to do something similar in VBA, I have a custom class, and I would like to keep a list of objects in that class (or collection as I think it's called in VBA) and then perform for each loops on them to read off their individual properties.

Anyone here familiar with both .NET and VBA that knows what I'm talking about?