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 vote310 views1 answer
Ribbon show/hide
VBA
1 vote312 views2 answers
Vba function return array
VBA
0 vote317 views1 answer
Excel vba ternary
VBA
0 vote297 views1 answer
Vba exit while
VBA
0 vote314 views2 answers
Get excel file from email attachment in vba
VBA
6 votes343 views1 answer
Excel vba check if a string only contains letters
VBA
0 vote330 views1 answer
Excel named range sum
VBA
0 vote296 views1 answer
Vbs send keys
VBA
0 vote315 views1 answer
Power query M substract minimum value of column -dax
VBA
5 votes329 views1 answer
Excel vba second byte from INTEGER
VBA