1

I would like to assign keyboard shortcuts to Excel macros that use keys other than the standard Ctrl + {alpha character}. Based on this post it sounds like it is possible but I am not sure how:

There are 3 different kinds of keyboard shortcuts I know of:

  1. Ones like Ctrl-C for Copy
  2. Ones like Alt-E-S-V for Edit > Paste
  3. Special > Values A shortcut key combo you assign to your own macro

    . . .

    With #3 it's still the same as it was in earlier versions, just go into the Macro dialog and change the shortcut in Options. You only have the choice of Ctrl and one key, I believe. With VBA you can actually create longer combos like Ctrl-Shft-N (one of my favorites).

Link to original

Doug, would you mind providing additional detail?

Improve this question
1
  • That's a 4 1/2 year old post. Doug hasn't visited the site in almost a year. Can you explain what aspect you're having difficulty with?
    – fixer1234
    Commented Mar 26, 2015 at 20:34

1 Answer 1

Reset to default
0

You can use OnKey to assign a macro to just about any single keystroke. See:

https://www.youtube.com/watch?v=MbHYJOvdv8s

Improve this answer
1
  • Please quote the essential parts of the answer from the reference link(s), as the answer can become invalid if the linked page(s) change.
    – DavidPostill ♦
    Commented Mar 26, 2015 at 21:58

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .