Shortcut key and UserForm

  • Thread starter Thread starter Cerberus
  • Start date Start date
C

Cerberus

I want to use a shortcut key (Ctrl+z) to activate a UserForm but don't know
for sure it is possible or how to go about it. I've always used a Command
Button or a _Click() in the past. Any ideas on how to go about this? Thanks
in advance.
 
I wouldn't recommend using Ctrl + z, because that is the undo method for
Office. Your users may not like that.
 
As Ryan Says, probably best not to use Ctrl Z.

Try the following in the open/close events to add/remove a shortcut for
Shift-Ctrl-Z, to call your macro that shows the form

Sub auto_Open()
Application.OnKey "+^Z", ThisWorkbook.Name & "!ShowFrmMyStuff"
End Sub

Sub Auto_Close()
Application.OnKey "+^Z"
End Sub

Sub ShowFrmMyStuff()
UserForm1.Show
End Sub

Regards,
Peter T
 
Back
Top