Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a piece of VBA code that does the following: It adds to the Worksheet
Menu Bar a control of the type msoControlPopup (i.e. a new menu), and then it adds to this new control a control of the type msoControlButton (i.e. a new menu item). With Caption = "&New menu point" I only have to press "N" once the menu is open. To add a direct shortcut, I wrote Application.OnKey "+^{N}", "ShowForm" so I can execute ShowForm by pressing Ctrl+Shift+N. I'd like to have this displayed next to the menu item, like e.g. in the File menu where it says "Ctrl+N" next to the "New..." item. How can this be done? I didn't find a property or anything to do the job. Thanks in advance, Benjamin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Popup Menu / Shortcut Menu | Excel Discussion (Misc queries) | |||
Missing "Custom View" entry from View menu | Excel Discussion (Misc queries) | |||
custom menu doesn't drop down via shortcut | Excel Programming | |||
custom menu doesn't drop down via shortcut | Excel Programming | |||
custom menu doesn't drop down via shortcut | Excel Programming |