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

User · Answer

Here is how to assign a keyboard shortcut to a custom macro in Word 2013. The scenario is you created a macro named "fred" and you want to execute the macro by typing Ctrl+f.

Click on File, Options.
Click on Customize Ribbon (from my perspective this is the non-intuitive step).
Click "Keyboard shortcuts: Customize" button.
In the Categories listbox scroll down to the buttom and select Macros.
The Macros list box should now show the list of custom macros. Select "fred".
Click the "Press new shortcut key" textbox to make it active.
Type Ctrl+f. This should appear in the textbox.
Look at the "Current keys" listbox. In this case it shows "Currently assigned to NavPaneSearch".
If you don't mind overriding that default, click the "Assign" button on the lower-left to assign "Ctrl+f: to run your "fred" macro.

By default the assignment is saved in the Normal.dotm document template. If this keyboard assignment is unique to this document then you may wish to change the "Save changes in" dropdown to your document name.

User · Answer

You can add some ALT Letter shortcuts to the VBA editor environment   I added ALT C to Comment selected text lines and A X to Uncomment selected text lines    In the VBE  right-click on a toolbar and select Customize Optionally create a new toolbar Select the Command Tab and  Edit  in the Categories listbox   Find  Comment Block  in the Commands listbox   Click and drag it to the target toolbar   Left-click on it to open the context popup menu and select  Image and Text    Replace the name with  amp C  Repeat step 3 for the Uncomment Block command and replace the name with  amp X  Close the Customize popup window    There are built-in Alt Letter commands that cannot be used for new shortcuts using letters  A D E D H I O Q R T V W

User · Answer

Write a vba proc like   Sub E 1       Call sndPlaySound32 ThisWorkbook Path  amp    e1 wav   0      Range  AG   amp   ActiveCell Row   Select  go to column AG in the same row End Sub   then go to developer tab  macros  select the macro  click options  then add a shortcut letter or button

User · Answer

The problem that I had with the above is that I wanted to associate a short cut key with a macro in an xlam which has no visible interface  I found that the folllowing worked  To associate a short cut key with a macro  In Excel  not VBA  on the Developer Tab click Macros - no macros will be shown Type the name of the Sub The Options button should then be enabled Click it Ctrl will be the default Hold down Shift and press the letter you want eg Shift and A will associate Ctrl-Shift-A with the Sub

User · Answer

F5 is a standard shortcut to run a macro in VBA editor  I don t think you can add a shortcut key in editor itself  If you want to run the macro from excel  you can assign a shortcut from there   In excel press alt F8 to open macro dialog box  select the macro for which you want to assign shortcut key and click options  there you can assign a shortcut to the macro

User · Answer

F function keys  F1 F2 F3 F4 F5 etc   can be assigned to macros with the following codes    Sub A 1       Call sndPlaySound32 ThisWorkbook Path  amp    a1 wav   0  End Sub  Sub B 1       Call sndPlaySound32 ThisWorkbook Path  amp    b1 wav   0  End Sub  Sub C 1       Call sndPlaySound32 ThisWorkbook Path  amp    c1 wav   0  End Sub  Sub D 1       Call sndPlaySound32 ThisWorkbook Path  amp    d1 wav   0  End Sub  Sub E 1       Call sndPlaySound32 ThisWorkbook Path  amp    e1 wav   0  End Sub   Sub auto open       Application OnKey   F1     A 1      Application OnKey   F2     B 1      Application OnKey   F3     C 1      Application OnKey   F4     D 1      Application OnKey   F5     E 1  End Sub

User · Answer

For assigning a keyboard key to button on the sheet you can use this code  just copy this code to the sheet which contain the button   Here Return specifies the key and get detail is the procedure name   Private Sub Worksheet SelectionChange ByVal Target As Range       Application OnKey   RETURN     get detail   End Sub   Now within this sheet whenever you press Enter button the assigned macro will be called

User · Answer

According to Microsoft s documentation  On the Tools menu  point to Macro  and then click Macros   In the Macro name box  enter the name of the macro you want to assign to a keyboard shortcut key   Click Options   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   If you want to include a description of the macro  type it in the Description box   Click OK   Click Cancel

User · Answer

I ran into this problem myself  The only solution I have is to record the macro in an excel workbook first  Then  drag and drop THE MODULE from the open workbook into the add-in modules  This will be a copy of the above module  but the keyboard shortcut you assigned to it will thankfully persist   I just record a garbage macro and move it in there  then copy the code from my real module afterwords    Felt so great to figure this out  I felt like I had to reply to the 5 year old posts I found on the subject

[excel] Assign keyboard shortcut to run procedure

Examples related to excel

Examples related to vba

Examples related to keyboard-shortcuts