Aug 09 2022 11:26 PM
The shortcuts in Excel don't just start with Ctrl.
This article describes the keyboard shortcuts, function keys, and some other common shortcut keys in Excel for Windows, macOS, iOS, Android, Web.
..or Define your own keyboard shortcuts
For that you need to record macros. Macros make it possible to record and save a sequence of work steps. If you then run the macro, Excel will then automatically perform the same steps. The practical thing about it: you can assign key combinations to macros and activate them quickly.
Hope I could help you with these information / links.
I know I don't know anything (Socrates)
Aug 09 2022 11:51 PM
Aug 10 2022 12:12 AM
We can use the OnKey method to define a keyboard shortcut. We define the key combination and the macro to be executed.
For example, the percent sign % represents the ALT key.
For more keyboard shortcuts, see the Excel developer reference for the Application.OnKey method.
Here is the code for the CTRL+ENTER key combination in VBA ^~ .
You can specify any key combination including SHIFT, CTRL, and ALT.
I know I don't know anything (Socrates)
Aug 15 2022 12:54 AM
@NikolinoDE Thank you again for your help. I had hoped to avoid getting into VBA but I shall take a look at how the macro appears in VBA and see if I can modify it.