How to use Alt keys + symbol keys to invoke a macro?

K

keithb

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
 
C

Chip Pearson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

shortcut keys 7
Assigning a shortcut key with Alt Gr 1
use of arrow keys in Excel 10
Chrome keyboard shortcuts 2
Macro keys to avoid 3
I have nearly run out of Shortcut Keys 4
So then how to a get arrow keys to control a spinbutton? 1
Shortcut keys not working .... <grrrr> 2

Top