VBA Adding a class to a collection [duplicate] VBA Adding a class to a collection [duplicate] vba vba

VBA Adding a class to a collection [duplicate]


Remove the parentheses.

holdings.Add h

Otherwise you are trying to add to the collection the value of the default property of your Holding instance, and it doesn't have a default property.