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?
Bookmarks