Is it possible to use keys like ALT for assigning shortcut key to macros in Excel?

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Is it possible to use keys like ALT for assigning shortcut key to macros in Excel?

FAQ

Thread Tools

Display Modes

12-23-2023, 09:18 PM

soroush.kalantari soroush.kalantari is offline

Windows 10 Is it possible to use keys like ALT for assigning shortcut key to macros in Excel?

Office 2021

Competent Performer

Join Date: Jun 2021

Posts: 124

soroush.kalantari is on a distinguished road

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)

Tags

onkey, shortcut

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Problem using shortcut keys	14spar15	Excel	3	09-14-2020 11:00 PM
Assigning shortcut keys via a macro file	alex100	Word VBA	6	06-26-2020 09:27 AM
Shortcut keys in Find&Replace	fsdance	Word	0	02-11-2011 03:27 PM
cant use shortcut keys (ctrl+c/v/z...)	laro	Office	0	10-08-2010 11:01 PM
Can't Assign Shortcut Keys	Vicki F.	Word	0	04-17-2010 03:03 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:19 AM.