Breaking News: Grepper is joining You.com. Read the official announcement!

excel vba close form escape key

VasteMonde answered on February 7, 2021 Popularity 3/10 Helpfulness 7/10

answer excel vba close form escape key

excel vba close form escape key

Comment

' In the userform code (must also be command controls if any, 
' for example buttons, for Keypress event)
Private Sub UserForm_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger)
    If KeyAscii = 27 Then Unload Me
End Sub
' Or on at least one / all buttons:
button.Cancel = True
' Or if none add a button to the userform with:
With button
    .Height = 0
    .Width = 0
    .Cancel = True
End Width

Popularity 3/10 Helpfulness 7/10 Language vb

Source: Grepper

Tags: excel key vba

Link to this answer
Share Copy Link

Contributed on Feb 07 2021

VasteMonde

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

excel vba close form escape key

Contents

More Related Answers

excel vba close form escape key

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.