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

3 votes227 views1 answer
Vba double quote
VBA
0 vote236 views1 answer
Search for text in every worksheet excel visual basic
VBA
0 vote276 views1 answer
Application.ExecutablePath VB.NET
VBA
0 vote235 views1 answer
Vba keep command window open
VBA
3 votes220 views1 answer
Excel vba get the workbook full file name with path
VBA
0 vote240 views1 answer
Excel vba set cell value to empty
VBA
6 votes229 views1 answer
Excel vba check if a string only contains alpha characters
VBA
0 vote226 views1 answer
Vb run command
VBA
0 vote206 views1 answer
Vba argument is set
VBA
0 vote232 views1 answer
Excel vba copy range with filter
VBA