Using short cut key board combinations to run macro
-
- SilverLounger
- Posts: 1868
- Joined: 25 Jan 2010, 14:00
- Location: Conroe, Texas
Using short cut key board combinations to run macro
I may be reaching to the out most part of our universe but is it possible to use different short cut key board combinations to run a line of code.
-
- Administrator
- Posts: 78574
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Using short cut key board combinations to run macro
You can assign a keyboard shortcut to a macro: select the macro in the Macros dialog and click Options...
You can't assign a keyboard shortcut to an individual line of code.
You can't assign a keyboard shortcut to an individual line of code.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- SilverLounger
- Posts: 1868
- Joined: 25 Jan 2010, 14:00
- Location: Conroe, Texas
Re: Using short cut key board combinations to run macro
So if I were to start a macro then add some additional code, I could then use this approach
-
- Administrator
- Posts: 78574
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
- SilverLounger
- Posts: 1868
- Joined: 25 Jan 2010, 14:00
- Location: Conroe, Texas
Re: Using short cut key board combinations to run macro
Hi Hans
Let say I start recording a macro select “g†as my short cut, then press OK, then continue by let say selecting a cell, then stop recording. Now I open the macro to edit and then add more addition code to the already existing code.
Let say I start recording a macro select “g†as my short cut, then press OK, then continue by let say selecting a cell, then stop recording. Now I open the macro to edit and then add more addition code to the already existing code.
-
- Administrator
- Posts: 78574
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Using short cut key board combinations to run macro
You can assign a macro to a shortcut of the form Ctrl+character on keyboard or Shift+Ctrl+character on keyboard. You cannot assign a macro to the "g" key, for if you did that, you wouldn't be able to enter the letter "g" any more...
You can edit the macro any way you like; the keyboard shortcut will always run the current (latest) version of the macro.
You can edit the macro any way you like; the keyboard shortcut will always run the current (latest) version of the macro.
Best wishes,
Hans
Hans
-
- SilverLounger
- Posts: 1868
- Joined: 25 Jan 2010, 14:00
- Location: Conroe, Texas
Re: Using short cut key board combinations to run macro
Thank you Hans
I apologize, I did mean with Ctrl+g on keyboard not just a letter.
I thank you for your most helpful assistance
I apologize, I did mean with Ctrl+g on keyboard not just a letter.
I thank you for your most helpful assistance