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

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