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 vote150 views1 answer
Vba add shape oval
VBA
1 vote170 views1 answer
Excel vba last row of range
VBA
0 vote186 views1 answer
How to enter Vbox manage commands
VBA
1 vote171 views1 answer
Excel date to unix timestamp
VBA
4 votes153 views1 answer
Excel vba check cell not empty
VBA
3 votes173 views1 answer
Excel vba get the workbook full filename with path
VBA
0 vote159 views1 answer
System.Runtime.InteropServices.COMException: 'Call was rejected by callee. (Exception from HRESULT: 0x80010001
VBA
0 vote149 views1 answer
Excel vba disable screen update
VBA
0 vote169 views1 answer
Vba variable number of arguments
VBA
6 votes171 views1 answer
Excel vba check if a string only contains letters
VBA