excel - Assign keyboard shortcut to run procedure

Question

When I press F5 in the VBA editor I would always like to run my "Sub Skynet()" procedure. Is there any way to assign a keyboard shortcut to this procedure.

Answer 1

According to Microsoft's documentation

1. On the Tools menu, point to Macro, and then click Macros.

2. In the Macro name box, enter the name of the macro you want to assign to a keyboard shortcut key.

3. Click Options.

4. If you want to run the macro by pressing a keyboard shortcut key, enter a letter in the Shortcut key box. You can use CTRL+ letter (for lowercase letters) or CTRL+SHIFT+ letter (for uppercase letters), where letter is any letter key on the keyboard. The shortcut key cannot use a number or special character, such as @ or #.

   Note: The shortcut key will override any equivalent default Microsoft Excel shortcut keys while the workbook that contains the macro is open.

5. If you want to include a description of the macro, type it in the Description box.

6. Click OK.

7. Click Cancel.