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

 

[mikerickson]

The Application.Caller might do what you want.

 

[Jaafar Tribak]

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

You can't use Form labels on userforms !

 

[RoryA]

the active label’s (i.e. just clicked) userform caption.

No idea what that means. Is it a label on a userform? If so, do you want the label caption or the form caption? If not, what have userforms got to do with it?

 

[Trebor76]

Hi there,

Thanks for the replies.

I have tried Application.Caller but this isn't for a label (as far as I can teel anyways).

If so, do you want the label caption

Yes!! I just want the caption (it's name here as I don't change it after it's been set) of the label I have clicked.

Thanks again,

Robert

 

[RoryA]

On a userform or worksheet? If userform, use its click event; if sheet, application.caller is correct if this is in a macro assigned to the label.

 

[Trebor76]

Hi Rory,

It's a userform. Perhaps the following will show what I'm trying to do:

Private Sub lbl04_Click()
   
   Dim strMyName As String
   
   strMyname = 'How would I return "lbl04" to the 'strMyName' variable?
   
End Sub

Kind regards,

Robert

 

[RoryA]

You'd need to type it in (activecontrol won't work for labels).

 

[Trebor76]

OK then. I had this but thought (was hoping) the control would be intuitive (perhaps by grabbing the caption somehow).

Thanks for the responses / help

 

[RoryA]

Can I ask why you need it, given that you have to put the code in the click event anyway?