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.