Shortcut keys and UserForm

[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.

 

[Jay Freedman]

In order to display a userform, you have to call its .Show method from a
regular macro. To make a shortcut, then, you make a shortcut for the macro
(http://www.word.mvps.org/FAQs/Customization/AsgnCmdOrMacroToHotkey.htm),
not for the userform itself.

Be aware that by default the Ctrl+Z shortcut is already assigned to the Undo
command, so you might want to pick a different one.

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

 

[Cerberus]

Thank you Jay!

In order to display a userform, you have to call its .Show method from a
regular macro. To make a shortcut, then, you make a shortcut for the macro
(http://www.word.mvps.org/FAQs/Customization/AsgnCmdOrMacroToHotkey.htm),
not for the userform itself.

Be aware that by default the Ctrl+Z shortcut is already assigned to the Undo
command, so you might want to pick a different one.

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.



.