Application.OnKey syntax for + and - keys

H

Hotbird

I want to assign the + and - keys to run a pair of Excel macros, and am using
the following code

Application.OnKey "{+}", "NextS" ' NEXT
Application.OnKey "{-}", "PrevS" ' PREVIOUS

This works, but not as intended. It responds to the + key (shared with =),
and the - key (shared with _), but resolutely ignores the dedicated + and -
keys on the right hand edge of my keyboard. I think most people prefer to
use single-press + and - keys, and am searching for the alternative
assignations which will map the dedicated + and - keys to the desired
Procedures.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top