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 vote110 views1 answer
Excel vba extract year
VBA
0 vote116 views1 answer
Vba collection key list
VBA
1 vote121 views1 answer
Excel vba saveas force overwrite
VBA
0 vote116 views1 answer
Refresh token em vb net
VBA
0 vote127 views1 answer
For each item in folder outlook vba
VBA
0 vote117 views1 answer
Vb get ip address
VBA
0 vote130 views1 answer
Excel vba paste all to each sheet in workbook
VBA
0 vote136 views1 answer
Vba foreach 2d array
VBA
-1 vote116 views1 answer
System.Data.OleDb.OleDbException: 'No value given for one or more required parameters.'
VBA
0 vote128 views1 answer
Vba table header name
VBA