accessing members of a class object passed in as variant type?

[vientito]

I have a subroutine which accepts variant user-defined type because I want to make it general enough for all my class objects. They all contain a particular member called dirtyflag so I would like to use this subroutine to process and access this member no matter what class object is passed inside.

But VBA does not seem to like this kind of practice. During runtime it gives me error.

So, I suppose VBA is not able to resolve type at runtime to access the member variable?

So does it mean I have to create different subroutines catering to each class object, no matter how similar they all appear?

Please Login or Register  to view this content.

[Leith Ross]

Hello vientito,

In VBA the object must be of the class that has dirtyflag as a property.

[vientito]

I have found out the reason behind. I have declared this member as a friend and it seems that it won't work with late-binding object at all. Once I put public instead everything works