Set variable to command button property 1

[dolfin13]

How would I refer to the caption of a button that was just clicked?

I would like to set a variable to the caption of cmd button in the click event of said button.

Thanks in advance, my mind is in the wrong place today.

 

[PHV]

Something like this ?
Me![command button name].Caption = "You've clicked me !"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Eupher]

Or this:

Dim MyVar As String
MyVar = Me!MyButton.Caption

Ken S.

 

[dolfin13]

sort of...

but I have many buttons, and wondered if there is a way to refer to the that was just clicked.

Private Sub cmdButton_Click()

Dim strCaption As String

strCaption = Me.[button that was just pressed].Caption

is there a way to do this?

Thanks for the quick reply, I'm sorry if I'm being confusing.

 

[PHV]

OOps, my lack of english language knowledge ...

 

[Eupher]

Try this:

Dim ctrl As Control
Dim strCaption As String
Set ctrl = Screen.ActiveControl
strCaption = ctrl.Caption

Ken S.

 

[dolfin13]

That's what I'm looking for!

Thanks a million!!!