Thread: [Solved] Is it possible to use keys like ALT for assigning shortcut key to macros in Excel?
View Single Post
 
Old 12-23-2023, 09:18 PM
soroush.kalantari soroush.kalantari is offline Windows 10 Office 2021
Competent Performer
  
Join Date: Jun 2021
Posts: 124
soroush.kalantari is on a distinguished road
Default
I have found the correct answer and have changed my mind: Yes it is possible to use ALT key for assigning shortcuts to macros. The point is the line “+%{R}” must be changed to “^%R”. (see the “Table of Shortcut Key Combinations for Application.OnKey method” section of this link)
Reply With Quote