Excel Userform - Trigger Hidden Buttons With Keyboard Combination Shortcuts ExcelVbaIsFun

In this Excel Userform tip, we expound on last week's quick tip and learn how to make hidden buttons that can trigger macros from Keyboard Combinations using Accelerator keys. That's when you press Alt+ another key. Check it out!

Fantastic Developer Tools:

[wayneedmondson]

Hi Dan.. cool trick. You can also set the button height or width to 0 and it will not appear when the form loads. The disadvantage there is that you can't see it in design mode and have to remember to use the drop down from the properties window if you want to select it and make any changes. I've also used the trick of putting it under one of the other objects on the form, like another button or label. I like your idea of putting it under an empty label, since it at least gives you a visual cue in design mode to remind yourself that you hid the button under it. If you set the Visible property to False, it will not appear when you run the form, but sadly the accelerator key won't work if Visible is False. Thanks for the great User Form tips.. always learn something new and fun at your channel :)) Thumbs up!!

[eCabinetstipsandtricks]

Thanks, Dan. I use hidden labels to get the row and/ or column numbers to use when working with list boxes. While I have your attention, is it possible to enable the minimize button on a user form that would allow the user to click it and minimize the form itself to the taskbar?

[sridharkrishnappanavanerth]

Sir, i am working on a inventory project, i am using multi page control with 3 pages for Sales, Purchase and inventory respectively. i want to display 3 list box one each for all the three pages.when i shift from one page to other then my lists boxes should update accordingly. please demonstrate this in a video. thanks

[mr.write]

escape on button but not in the userform ?

[thomasfergusen]

hello, i have choosed true option of tabstop property of a label control but when i pressed tab after run, it didnt work. then i closed userform and checked the tabstop property of the label guess what? it has been returned to false... i was suprised. can you explain the reason of why please, thanks for one more of benefit tips God Bless!

[BogdanDonescu]

Hello! Actually you don't need to cover the button or get it out of sight, you just need to make one of its dimensions (height or width) zero. HTH.

[kristjanminnatharmet]

or just add a macro shortcut from macro options