ShortcutKey assigning in VBA
Hi,
is it possible to assign a shortcut key to a menu-item? You can assign the text with the .ShortcutText but how can you make it work (if you press the ShortcutText, it should do the job!) Thanks Jos Vens |
ShortcutKey assigning in VBA
Hi Jos,
No, but you can assign a short cut to the macro independently of creating a menu item so you have what you want. If you are going to have both you might include the shortcut within the menu item description. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Jos Vens" wrote in message ... Hi, is it possible to assign a shortcut key to a menu-item? You can assign the text with the .ShortcutText but how can you make it work (if you press the ShortcutText, it should do the job!) Thanks Jos Vens |
ShortcutKey assigning in VBA
Thanks David,
is the OnKey method, the only way to accomplish that in VBA? Thanks Jos "David McRitchie" schreef in bericht ... Hi Jos, No, but you can assign a short cut to the macro independently of creating a menu item so you have what you want. If you are going to have both you might include the shortcut within the menu item description. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Jos Vens" wrote in message ... Hi, is it possible to assign a shortcut key to a menu-item? You can assign the text with the .ShortcutText but how can you make it work (if you press the ShortcutText, it should do the job!) Thanks Jos Vens |
ShortcutKey assigning in VBA
Hi Jos,
I don't know about the second part, but the first part (pass) for a list of macros is certainly not needed. See http://www.mvps.org/dmcritchie/excel...nctionsAndSubs but I tried putting that list in in place of the first part and the shortcuts were out of sync. But I did say that it was very suitable for me -- it takes too long. Wish I could extract the shortcut key directly for the bookname!modulename.macroname for the List Functions and Subs table., and also from when I run through the menus, I should be able to pick up the shortcut keys but could not. barhopper.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Jos Vens" wrote in message ... Thanks David, is the OnKey method, the only way to accomplish that in VBA? Thanks Jos "David McRitchie" schreef in bericht ... Hi Jos, No, but you can assign a short cut to the macro independently of creating a menu item so you have what you want. If you are going to have both you might include the shortcut within the menu item description. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Jos Vens" wrote in message ... Hi, is it possible to assign a shortcut key to a menu-item? You can assign the text with the .ShortcutText but how can you make it work (if you press the ShortcutText, it should do the job!) Thanks Jos Vens |
All times are GMT +1. The time now is 04:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com