Refer to userform objects in a macro

[SIMBAtheCAT]

Hi, Good morning all,

So, simple question : Is it possible to refer to a userform objects like a ListBox from a macro example :

The userform code could be :

Please Login or Register  to view this content.

And the macro code would be :

Please Login or Register  to view this content.

[nathansav]

Yes, you could do it a couple of ways, you could either create custom properties.

something like this in the form

Please Login or Register  to view this content.

then reference,

Please Login or Register  to view this content.

or you can just open the form into an object and reference the object frm.listbox1.value.


I am not in Excel at the mo, so cant properly test, but i'll post back in about 30mins.

[nathansav]

Yes, you could do it a couple of ways, you could either create custom properties.

something like this in the form

Please Login or Register  to view this content.

then reference,

Please Login or Register  to view this content.

or you can just open the form into an object and reference the object frm.listbox1.value.


I am not in Excel at the mo, so cant properly test, but i'll post back in about 30mins.

[SIMBAtheCAT]

Yes, I tried just stating the userform name before the object and it works.

Ex :

Please Login or Register  to view this content.

Thank you for your help.