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

4 votes239 views1 answer
Vba create directory
VBA
0 vote238 views1 answer
Vba string start with
VBA
1 vote244 views1 answer
Excel how to format bytes as KB, MB, GB
VBA
0 vote283 views1 answer
Vba code for cutoff time
VBA
0 vote231 views1 answer
Vb get ip address
VBA
0 vote226 views1 answer
Vba remove numbers from string
VBA
0 vote313 views1 answer
Excel vba add reference programmatically
VBA
5 votes271 views1 answer
Excel vba how to unit test vba code
VBA
0 vote238 views1 answer
Excel vba delete folder
VBA
0 vote224 views2 answers
Excel vba copy paste after last row
VBA