Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
shortcut has change or move so this shortcut can not open bakerstreet Excel Worksheet Functions 2 April 2nd 10 01:21 PM
MAC shortcut key ShaneDevenshire Excel Discussion (Misc queries) 3 May 24th 07 03:21 AM
Shortcut key Steph Excel Programming 5 June 1st 06 08:10 PM
Shortcut Brian Brandt Excel Discussion (Misc queries) 4 February 24th 06 05:02 PM
Add shortcut key or hot key via vba Job Excel Programming 2 February 4th 05 08:27 PM


All times are GMT +1. The time now is 01:41 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"