Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shortcut Key
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shortcut Key
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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
shortcut has change or move so this shortcut can not open | Excel Worksheet Functions | |||
MAC shortcut key | Excel Discussion (Misc queries) | |||
Shortcut key | Excel Programming | |||
Shortcut | Excel Discussion (Misc queries) | |||
Add shortcut key or hot key via vba | Excel Programming |