We can use the Esc key to close most of the built-in dialog boxes in Excel, and most other applications.
How can we assign the Esc key to close an Excel VBA UserForm?
Asked
Active
Viewed 85 times
0
-
1If you have a Command Button to unload the form you can change it's `Cancel` property to `True`. – Fadi Mar 07 '17 at 14:00
-
2Check the answer of `Jesus` here: http://stackoverflow.com/questions/20240677/close-userform-with-escape-button And my comment below it! :) – Vityata Mar 07 '17 at 14:05
-
Or check here: http://stackoverflow.com/questions/33244626/activate-userform-with-only-one-enter/33246450#33246450 – Ralph Mar 07 '17 at 14:06
-
Thanks to all, that solved my problem. – Haytham Amairah Mar 10 '17 at 04:01