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

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

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

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

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

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

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

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

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

[excel] Assign keyboard shortcut to run procedure

Examples related to excel

Examples related to vba

Examples related to keyboard-shortcuts