Excel vba close form escape key

' 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

Similar codes

0 vote284 views1 answer
VBA Sort RossetaCode
VBA
0 vote301 views1 answer
Find database connection string vb
VBA
1 vote299 views1 answer
Shortcut to apply a formula to an entire column in excel
VBA
0 vote272 views1 answer
Vba exit while
VBA
8 votes324 views1 answer
Excel vba determine number of elements in a 1D array
VBA
0 vote285 views1 answer
Not allow form to be resized
VBA
0 vote300 views1 answer
Vba is integer
VBA
0 vote305 views1 answer
Vba random number
VBA
0 vote298 views1 answer
Vba range clear formatting
VBA
0 vote308 views1 answer
Style percent not found vba
VBA