ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Hide UserForm with Keyboard? (https://www.excelbanter.com/excel-programming/338485-hide-userform-keyboard.html)

bw

Hide UserForm with Keyboard?
 
Private Sub CmdClose_Click()
UserForm2.Hide
End Sub

Is there a way to accomplish this using the keyboard? For example, I'd like
to enter <ctrlc to accomplish the same thing.

Thanks,
Bernie



Doug Glancy

Hide UserForm with Keyboard?
 
Bernie,

Define an accelerator key in the properties window for the button. E.g., if
you use "C" as an accelerator that letter will be underlined on the button
and Alt-C will hide the Userform.

hth,

Doug

"bw" wrote in message
...
Private Sub CmdClose_Click()
UserForm2.Hide
End Sub

Is there a way to accomplish this using the keyboard? For example, I'd
like to enter <ctrlc to accomplish the same thing.

Thanks,
Bernie




bw

Hide UserForm with Keyboard?
 
Thanks a bunch, Doug!

Bernie

"Doug Glancy" wrote in message
...
Bernie,

Define an accelerator key in the properties window for the button. E.g.,
if you use "C" as an accelerator that letter will be underlined on the
button and Alt-C will hide the Userform.

hth,

Doug

"bw" wrote in message
...
Private Sub CmdClose_Click()
UserForm2.Hide
End Sub

Is there a way to accomplish this using the keyboard? For example, I'd
like to enter <ctrlc to accomplish the same thing.

Thanks,
Bernie







All times are GMT +1. The time now is 10:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com