How to assign a keyboard shortcut for an Excel VBA Macro

Excel macros are excellent time savers. It is a good idea to assign some keyboard shortcuts to trigger them quickly to make the most of them.

Assigning a keyboard shortcut when recording a macro

If you record a macro, you will notice an option to assign the keyboard shortcut directly while naming your macro.


Assigning Excel Key Board Shortcut for Recorded Macros



Assigning a keyboard shortcut for manually created a macro


When you manually create a macro you don’t see the keyboard shortcut option directly. To assign the shortcut select Options and assign the keyboard shortcut manually


Assigning Excel Key Board Shortcut for Manually Created Macros

Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>