The Key is the keyboard shortcut combination represented by key codes. The Application.OnKey method has two parameters for the Key and Procedure. Add a new line and start it with the command Application.OnKey followed by a space.Create a new macro and name it CreateShortcut (or whatever you choose to name the procedure),.In the VB editor, we are going to write some simple code to assign a macro to a keyboard shortcut. You can do this by clicking the Visual Basic button on the Developer tab, or pressing Alt+ F11. It also gives us more options and flexibility with our keyboard shortcuts. The Application.OnKey method allows us to create and delete the shortcuts. We can also use VBA code to create shortcut keys for macros. To delete the shortcut, simply repeat the process for accessing the Macro Options Window and then delete the character that you entered to create the shortcut. One way to avoid doing this is by adding Shift to the shortcut to make it a bit more complex. In the Macro Options Window, you can create the shortcut you want by adding a letter, number, or symbol.īe careful not to override an existing shortcut that you frequently use, such as Ctrl+ C to copy.After selecting the macro that you want to assign the shortcut to, click the Options button.(If you don't see the Developer tab on your ribbon, you can add it using these instructions.) Alternatively, you can use the keyboard shortcut Alt+ F8. Start by going to the Developer tab and clicking on the Macros button.Here are the instructions on how to set it up. We can use the Macro Options window in Excel to create a shortcut key to call the macro. I also explain the pros & cons of each method. These include the Macro Options window and VBA code for the Application.OnKey method. In this post we look at two popular ways to create the shortcut keys. This is especially true if you have to perform the same actions repeatedly. Assign-Keyboard-Shortcut-to-Macro.zip Download Create Your Own Keyboard Shortcuts to Run MacrosĪssigning keyboard shortcuts to simple or complex macros can help you work faster in Excel.
0 kommentar(er)
