ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   shortcut for add-In menu (https://www.excelbanter.com/excel-programming/354147-shortcut-add-menu.html)

kikde

shortcut for add-In menu
 
hi,

i created an add-In which provides a menu with sub menu-entries

menuMain
submenu CTRL+ALT+L

problem: The menu shortcut does not run. nothing happens.
if I click the menu entry with the mouse, everything is ok.
The shortcut is not blocked from another menu.

here is the sourcecode for the menu-creation:

Set cbctrl = objMenu.Controls.Add(msoControlButton)
With cbctrl
.Caption = "submenu"
.OnAction = "CreateReport"
.ShortcutText = "CTRL+ALT+L"
End With

can anyone help?

Thank's

Jens


Tom Ogilvy

shortcut for add-In menu
 
You would have to set the shortcut keys for the assigned onaction macro to
your shortcut key sequence.

Application.OnKey "+^%l", "CreateReport"


--
Regards,
Tom Ogilvy



"kikde" wrote in message
...
hi,

i created an add-In which provides a menu with sub menu-entries

menuMain
submenu CTRL+ALT+L

problem: The menu shortcut does not run. nothing happens.
if I click the menu entry with the mouse, everything is ok.
The shortcut is not blocked from another menu.

here is the sourcecode for the menu-creation:

Set cbctrl = objMenu.Controls.Add(msoControlButton)
With cbctrl
.Caption = "submenu"
.OnAction = "CreateReport"
.ShortcutText = "CTRL+ALT+L"
End With

can anyone help?

Thank's

Jens





All times are GMT +1. The time now is 10:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com