Thread: How to use Alt keys + symbol keys to invoke a macro?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default 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 With QuoteReply With Quote