Prev: Run-time error '5991'
Next: Thanks so much I have one other question
From: Cerberus on 20 Jan 2010 08:51
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.
From: Jay Freedman on 20 Jan 2010 10:30
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 FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

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.


From: Cerberus on 20 Jan 2010 12:10
Thank you Jay!

"Jay Freedman" wrote:

> 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 FAQ: http://word.mvps.org
> Email cannot be acknowledged; please post all follow-ups to the newsgroup so
> all may benefit.
>
> 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.
>
>
> .
>
 | 
Pages: 1
Prev: Run-time error '5991'
Next: Thanks so much I have one other question