Check to See If Button Was Clicked in Shown UserForm1

[excelvbameche]

Hi - I'm trying to figure out how to run a line of code if one of three buttons was selected in a shown UserForm1.

This is what I have so far:

Private Sub CommandButton1_Click()

If UserForm1.CommandButton1.TakeFocus******* Then


Do This


ElseIf UserForm1.CommandButton2.TakeFocus******* Then


Do This


ElseIf UserForm1.CommandButton3.TakeFocus******* Then

Do This


End If

End Sub

...

User Form:

Private Sub CommandButton1_Click()


UserForm1.Hide


End Sub


Private Sub CommandButton2_Click()


UserForm1.Hide


End Sub


Private Sub CommandButton3_Click()


UserForm1.Hide


End Sub

Not sure if the ".TakeFocus*******" handle is the way to go, or what I'm doing wrong in general.

Thank you for your time!

 

[DanteAmor]

At the moment of pressing the button you already have the control on the button itself, in addition the button is the selected control, it is not necessary to ask which button has the focus.

You need somethig like this:

[COLOR=#333333]Private Sub CommandButton1_Click()[/COLOR]
[COLOR=#333333]  Do This[/COLOR]
[COLOR=#333333]End Sub[/COLOR]
[COLOR=#333333]Private Sub CommandButton2_Click()[/COLOR]
[COLOR=#333333]  Do This[/COLOR]
[COLOR=#333333]End Sub[/COLOR]
[COLOR=#333333]Private Sub CommandButton3_Click()[/COLOR]
[COLOR=#333333]  Do This[/COLOR]
[COLOR=#333333]End Sub[/COLOR]

 

[excelvbameche]

Thank you Dante!

What if I want to embed an If-Then statement in the code that references which button got clicked in the UserForm.

Thanks

 

[DanteAmor]

Thank you Dante!

What if I want to embed an If-Then statement in the code that references which button got clicked in the UserForm.

Thanks

Why do you want to embed the statement?

It is not necessary, because if you pressed button1, in button1 you know that you pressed button1:

Private Sub CommandButton1_Click()
  msgbox "You pressed the button1"
End Sub