Miceal Powell
New Member
- Joined
- Feb 21, 2025
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
Hi All,
I have seen a few older questions about adding an ALT Key to run a subroutine in an Excel Userform....
here is what I do...
The easiest way to add an "ALT" to a user form is by creating a button that is linked to your subroutine then create a "click" event for that button and assign the desired ALT key in the properties Window (F4) to the "Accelerator" item.
When your form is running ... holding the ALT Key and the Letter you selected will initiate the code.
BTW ... the code in the button you created can just call another subroutine if desired.
I typically hide the button created as I only access to code using the short cut.
I have seen a few older questions about adding an ALT Key to run a subroutine in an Excel Userform....
here is what I do...
The easiest way to add an "ALT" to a user form is by creating a button that is linked to your subroutine then create a "click" event for that button and assign the desired ALT key in the properties Window (F4) to the "Accelerator" item.
When your form is running ... holding the ALT Key and the Letter you selected will initiate the code.
BTW ... the code in the button you created can just call another subroutine if desired.
I typically hide the button created as I only access to code using the short cut.