Excel Userform - Use Custom KeyBoard Shortcuts For ANY Macro Throughout Your Userform - KeyUp Handle

[@amitsatnalika5760]

Can we assing any keyboard shortcut to run/ lauch userfrom , like we do for marco , let say control + U will launch and run the user form

[@mohamadadnan3958]

Thank you for the great information. My question is, what if there are more than one button? What is the change in the code?

[@Hey_Delight]

Thank you for the gifts of learning throughout 2020! A wonderful 2021!⛤🎆💖.

[@wayneedmondson1065]

Hi Dan.. nice technique! Thanks for sharing it :)) Thumbs up!! PS - Like the CTRL+G / Immediate Window as a scratchpad tip.. never thought of that..

[@ExcelVbaIsFun]

Awesome, Wayne! Glad that helps. Thanks for the comments and the thumbs up!

[@songokussj4cz]

Hi. If you have 800 controls, you have to have 800 rows for adding handlers. What about UserForm_Initialize() or UserForm_Activate() function with "InitControls" function that initializes all controls as a collection of custom classes clsMyControls (or clsMyListBox, clsMyButton, clsMyTextBox) and add a event there. Then you can just add 1 line to your new form and it works. :-) I know, not so beginner friendly. But There are like 99 % beginner tutorials and not much of advanced ones.

[@thomasfergusen5144]

thanks!

[@ExcelVbaIsFun]

Very welcome, thomas!