Custom keyboard shortcuts?

[ch1no]

How can I define a custom keyboard shortcut using non-letter letter keys. For example, I'd like to create a negative indent keyboard shortcut assigning the strokes as CTRL + SHIFT + <

[davesexcel]

I don't think so
here's a code

Please Login or Register  to view this content.

once the code is in place go to tools >macros >options and set the key stroke, needs to be a letter though

[ch1no]

Thanks Dave,

I'm fairly certain that there's a way to assign non-letter keyboard shortcuts. A financial modeling package called DealMaven (www.dealmaven.com) assigns non-letter keyboard shortcuts to various excel functions, but I don't want to pay them if the process is simple enough to do manually. I'm not sure if they use macros to assign those shortcuts. Knowing how to do this would be extremely useful for everyone since using shortcuts to perform mundane but often-used menu-item actions will reduce analysis time significantly.

[davesexcel]

Thanks Dave,

I'm fairly certain that there's a way to assign non-letter keyboard shortcuts. A financial modeling package called DealMaven (www.dealmaven.com) assigns non-letter keyboard shortcuts to various excel functions, but I don't want to pay them if the process is simple enough to do manually. I'm not sure if they use macros to assign those shortcuts. Knowing how to do this would be extremely useful for everyone since using shortcuts to perform mundane but often-used menu-item actions will reduce analysis time significantly.

Hi,
When you find a way please let us know.....

[mikerickson]

The OnKey event can be triggered my many combinations. The VBE help system entry would help you.

[davesexcel]

The OnKey event can be triggered my many combinations. The VBE help system entry would help you.

But will you be able to use ctrl- none letter to activate it?

[mikerickson]

OH,, Ctrl NONE!!! No! that's so odd that I failed to read it.

If it were possible, it would be a risky choice. If CTRL+ was a hot key, how would one press CTRL+C ?

Remarks
The Key argument can specify any single key; any key combined with ALT, CTRL, or SHIFT, or any combination of these keys (in Windows); or COMMAND, CTRL, OPTION, or SHIFT, or any combination of these keys (on the Macintosh). Each key is represented by one or more characters, such as "a" for the character a, or "{ENTER}" for the ENTER key.
To specify characters that aren't displayed when you press the corresponding key (ENTER or TAB, for example), use the codes listed in the following table. Each code in the table represents one key on the keyboard.
Key Code
BACKSPACE {BACKSPACE} or {BS}
BREAK {BREAK}
CAPS LOCK {CAPSLOCK}
CLEAR {CLEAR}
DELETE or DEL {DELETE} or {DEL}
DOWN ARROW {DOWN}
END {END}
ENTER (numeric keypad) {ENTER}
ENTER ~ (tilde)
ESC {ESCAPE} or {ESC}
HELP {HELP}
HOME {HOME}
INS {INSERT}
LEFT ARROW {LEFT}
NUM LOCK {NUMLOCK}
PAGE DOWN {PGDN}
PAGE UP {PGUP}
RETURN {RETURN}
RIGHT ARROW {RIGHT}
SCROLL LOCK {SCROLLLOCK}
TAB {TAB}
UP ARROW {UP}
F1 through F15 {F1} through {F15}

In Windows, you can also specify keys combined with SHIFT and/or CTRL and/or ALT. On the Macintosh, you can also specify keys combined with SHIFT and/or CTRL and/or OPTION and/or COMMAND. To specify a key combined with another key or keys, use the following table.
To combine keys with Precede the key code by
SHIFT + (plus sign)
CTRL ^ (caret)
ALT or OPTION % (percent sign)
COMMAND * (asterisk)

To assign a procedure to one of the special characters (+, ^, %, and so on), enclose the character in braces. For details, see the example.

This is what Excel says.