Using ALT Links in Userforms

[Miceal Powell]

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.

 

[Micron]

I'm not an Excel power user so I was wondering why you'd do this when keyboard shortcuts can run macros, so I had to test. Interesting that it seems you can't run code with keyboard shortcuts when a userform has the focus. At least I think that's the reason.