How to reference an active ActiveX control?

[cheoksoon]

Hi everybody,

I'm writing an 'on_click' event for one of my ActiveX labels.

But how do I reference itself in the code?

I need to derive the label's name when I click on it.

Is there a way on how to do it?

thanks...

 

[DanteAmor]

You need this:

Private Sub CommandButton1_Click()
  MsgBox CommandButton1.Caption
End Sub

 

[cheoksoon]

You need this:

Private Sub CommandButton1_Click()
  MsgBox CommandButton1.Caption
End Sub

Hey thanks!

That was easy.

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.