Object-oriented programming in VBA

[felix]

Hi guys,

Do you know how to get an object (or simply a structure without methods if such an animal exists in VBA) as an output of a function written in VBA?

I have tried to declare the function as an object type, but could not modify any of its filed inside the function ...

Thanks a lot !

[Bob Phillips]

Create a class.

[felix]

I created the class. The function is declared as the type defined by the class.

[Bob Phillips]

Then we need more info, more details.

[Paul_Hossler]

An example WB would be helpful, I'd like to see how to do that also

Paul

[Imaginative1]

I'm trying to do that too.