VBA to capture active userform label caption

[Trebor76]

Hi there,

I've been struggling with this for hours, which (in my mind anyway), should be an easy one.

All I want to do is set a string variable with the active label’s (i.e. just clicked) userform caption. The label is a form control not an ActiveX control.

Hope someone can help.

Regards,

Robert

 

[RoryA]

Where is MySelection? Can you not simply put the code from MySelection into the class and refer to lbl directly there?

 

[Trebor76]

MySelection is a macro in main module of the form. I'll have to let this go for tonight.

Cheers Rory

 

[RoryA]

You'd need to put it in a normal module rather than the form module, or make it public.

 

[Trebor76]

Can I manipulate a label from a normal module (if so would you mind providing a small example)