| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to use Alt keys + symbol keys to invoke a macro?
Is there a workaround that allows assigning key combinations to macos other
than Ctrl + a letter. I would like to ue Alt + a symbol, such as Alt + Left Arrow. Thanks, Keith |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to use Alt keys + symbol keys to invoke a macro?
You need to use the OnKey method of the Application object. See
VBA Help for OnKey. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "keithb" wrote in message ... Is there a workaround that allows assigning key combinations to macos other than Ctrl + a letter. I would like to ue Alt + a symbol, such as Alt + Left Arrow. Thanks, Keith |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| shift and down keys in macro | Excel Discussion (Misc queries) | |||
| Type a symbol useing shortcut keys rather the insert a symbol | Excel Discussion (Misc queries) | |||
| macro will not run with shortcut keys | Excel Worksheet Functions | |||
| cursor keys in a macro | Excel Programming | |||
| shortcut macro keys | Excel Programming | |||
Hybrid Mode
