Shortcut key and UserForm
 

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.

Shortcut key and UserForm
 

I wouldn't recommend using Ctrl + z, because that is the undo method for
Office. Your users may not like that.
--
Cheers,
Ryan


"Cerberus" wrote:

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.

Shortcut key and UserForm
 

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

"Cerberus" wrote in message
...
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.