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

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" <[email protected]> wrote in message
news:eC%[email protected]...
> 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
>