Getting the number of elements in a user defined type

Hi,

Let's say I have user-defined type:

Please Login or Register  to view this content.

The type has three elements (Name, Age, Pets). Is there some way that I can return the number of elements of a UDT like above?

Thanks a lot for reading!

No, there isn't. This would require reflection, which VBA does not support.

Depending on what you are actually trying to do, there may be other solutions

Hi !

Maybe reading the code via the CodeModule object of a VBComponent object from the VBProject object …

Thanks a lot for that - "Reflection" is new concept for me, thanks for letting me know about it!

Thanks for info - I'll certainly look into that.