On Jul 29, 5:04*pm, Dave Peterson wrote:
You can use the .cancel property for that commandbutton. *You can change it in
the properties window (for that commandbutton).

Or you can use code:

Option Explicit
Private Sub CommandButton1_Click()
* * MsgBox "Hi from Ok"
End Sub
Private Sub CommandButton2_Click()
* * Unload Me
End Sub
Private Sub UserForm_Initialize()
* * With Me.CommandButton1
* * * * .Caption = "Ok"
* * * * .Default = True
* * End With

* * With Me.CommandButton2
* * * * .Caption = "Cancel"
* * * * .Cancel = True
* * End With
End Sub

jayray wrote:

I have a form with the usual OK and Cancel buttons. To problems
whatsoever with those buttons. But I have a finicky user who asks if
he can just make the form disappear by pressing the Esc key (he
doesn't want to have to move his mouse to the Cancel button and click,
or use an Alt + accelerator key, or use the tab key to go there. As I
said, he's finicky.)

I'm drawing a blank on how to have Excel read an Esc key as a trigger
to hide and unload the form. Any suggestions?

--

Dave Peterson

I meant to say "No problems whatsoever with the OK and Cancel
buttons".

Thanks for the reply. The problem I am trying to solve is to make the
form disappear WITHOUT pressing either the OK or Cancel buttons on the
form. I would like the form to disappear by pressing the Esc key.