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 vote166 views1 answer
Vba test optional argument
VBA
3 votes178 views1 answer
Excel insert blank row for value change in column
VBA
0 vote164 views1 answer
Check range is in another range vba
VBA
0 vote173 views1 answer
Excel vba hide gridlines
VBA
0 vote174 views1 answer
Excel vba extract year
VBA
0 vote179 views1 answer
VBA Sort RossetaCode
VBA
0 vote173 views1 answer
Como ler subitem de um array em json usando vbnet
VBA
0 vote170 views1 answer
Make your computer talk vbscript
VBA
0 vote214 views1 answer
Vba excel parser xml
VBA
1 vote186 views1 answer
Excel vba first row in range
VBA