Loop through a "specific" property of the objects in a collection

[rkaczano]

I know I can loop though objects in a collection.

Is it possible to loop through a "specific" property of the objects in that collection?

For example. I have 500 instances of an object (obj) and I also have a custom collection (coll) and I would loop as follows through the objects in the collection.

For each obj in coll
'Do something
Next

Each obj has a property called OType:
300x instances have OType = "A"
100x instances have OType = "B"
75x instances have OType = "C"
25x instances haveOType = "D"

I want to be able to loop through those 4 distinct property values in the collection. This would loop 4 times instead of 500 times. The following does not work.

For each obj.OType in coll
'Do something
Next

Thanks

 

[6StringJazzer]

VBA will not dynamically look at object attributes for you and analyze them to tell you the range of values in that attribute. So yeah, what you tried can't work.

How did the A, B, C, and D values get assigned in the first place? That is the place you need to think about how to loop these four values. You may need to define those four values as their own collection, and you loop through that collection. Or an array. It's hard to get more specific without knowing how you determine and assign the value to each object.