Shortcut key to open a UserForm

[phantom1975]

I would like a UserForm to pop up when CTL + H is pressed on a particular sheet only. Any suggestions?

 

[dk]

Hi,

The easiest way would be to assign your macro to Ctrl H as normal and then check the name of the sheet before your form is shown. If the active sheet is the right one then the form will be shown e.g.

If ActiveSheet.Name = "The sheet" Then UserForm1.Show

 

[Al Chara]

Try the following setup:

'Place these two macros in the ThisWorkbook module
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.OnKey "^h"
End Sub

Private Sub Workbook_Open()
Application.OnKey "^h", "LoadForm"
End Sub

'Place this macro in a standard module, module1
Sub LoadForm()
If ActiveSheet.Name = "Sheet1" Then UserForm1.Show
End Sub

This code will only work once you have saved and reopened your workbook. The code will show userform1 when CTRL+h is pressed on Sheet1.

Note: CTRL+h will do nothing on the rest of the sheets.

 

[phantom1975]

That's pretty much what I thought. I wasn't sure if there was a way to code it in the UserForm itself.

 

[bklabel1]

This worked for me. I was using function keys so I used "{F3}" instead of the "^h" and it worked great.
Thanks,
Kevin