Shortcut Key

[toocold]

Good afternoon,

I would like to set up a key or combination of keys that would call a userform for me. Is it possible to do this? i.e. Alt"}" to call the MainMenu userform?

Thanks,
dw

[Tom Ogilvy]

Look in Excel VBA help at the Onkey method.

For that combination, assign a macro that has the command to show the form

Sub MyMacro()
MainMenu.Show
End Sub

for example.
--
Regards,
Tom Ogilvy

"toocold" <[email protected]> wrote in
message news:[email protected]...
>
> Good afternoon,
>
> I would like to set up a key or combination of keys that would call a
> userform for me. Is it possible to do this? i.e. Alt"}" to call the
> MainMenu userform?
>
> Thanks,
> dw
>
>
> --
> toocold
> ------------------------------------------------------------------------
> toocold's Profile:
http://www.excelforum.com/member.php...o&userid=31608
> View this thread: http://www.excelforum.com/showthread...hreadid=550683
>