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 vote313 views1 answer
Excel vba range contains
VBA
5 votes358 views1 answer
Excel vba low word from Long Integer
VBA
0 vote312 views1 answer
Vba type variable
VBA
0 vote340 views1 answer
Vba extract filename from path
VBA
0 vote327 views1 answer
Vba compare strings
VBA
5 votes366 views1 answer
Xlvba double quotes in string literal
VBA
1 vote319 views1 answer
Vba date to unix timestamp
VBA
0 vote364 views1 answer
Filesystemobject vba reference
VBA
1 vote321 views1 answer
Extract the second word in a text in excel
VBA
0 vote331 views1 answer
Excel vba clear filter
VBA