Hi,

I made a userform and I want to close this without pressing the Cancel
button or Close Button. is it possible to close it by pressing Esc
key.

Pls advise me.

Regards.

Shahzad

I think the Userform will close with the Esc Key pressed by default. It does
for me in Excel 2007.

If not, I'd use,

Private Sub UserForm_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal
Shift As Integer)

If KeyCode = 27 Then
Unload Me
End If

End Sub

"Shazi" wrote:

> Hi,
>
> I made a userform and I want to close this without pressing the Cancel
> button or Close Button. is it possible to close it by pressing Esc
> key.
>
> Pls advise me.
>
> Regards.
>
> Shahzad
>

Your form needs a button that has it's Cancel property = true. Put your code
to close the form in the cancel button's click event, eg

Private Sub CommandButton1_Click()
Unload Me
End Sub

Typically the button's caption would read "Cancel" or "Quit", so you could
click it or press Esc, but the button could be hidden off the form if you
want.

Regards,
Peter T

"Shazi" <(E-Mail Removed)> wrote in message
news:57676752-6231-4c74-a357-(E-Mail Removed)...
> Hi,
>
> I made a userform and I want to close this without pressing the Cancel
> button or Close Button. is it possible to close it by pressing Esc
> key.
>
> Pls advise me.
>
> Regards.
>
> Shahzad

lol, I've been using Peter T method without even realizing it. Peters
response is the way to go, it works for me. The Esc Key will not close the
UserForm by default.

Look under the Properties Window of the command button you wish to use to
Unload the Userform. Set the Cancel Property = True. Sorry for any
confusion.

Ryan

"RyanH" wrote:

> I think the Userform will close with the Esc Key pressed by default. It does
> for me in Excel 2007.
>
> If not, I'd use,
>
> Private Sub UserForm_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal
> Shift As Integer)
>
> If KeyCode = 27 Then
> Unload Me
> End If
>
> End Sub
>
> "Shazi" wrote:
>
> > Hi,
> >
> > I made a userform and I want to close this without pressing the Cancel
> > button or Close Button. is it possible to close it by pressing Esc
> > key.
> >
> > Pls advise me.
> >
> > Regards.
> >
> > Shahzad
> >