Assigning a shortcut to ctrl and shift and the number pad

[luv2glyd]

I am trying to assign a shortcut to run macro with a combination of keys pressed at the same time: control shift 1. The 1 is on the number pad rather than up near F1 key. Using the following code:

Please Login or Register  to view this content.

... and having no luck. Got the number pad onkey shortcuts from this post: http://www.excelforum.com/excel-prog...umber-pad.html

Thanks

[AlphaFrog]

Your code worked for me.

Use 35 with the num lock off and 97 with the num lock on.

[luv2glyd]

Still no luck. Maybe it has to do with Excel version? I have 2010...

[AlphaFrog]

Maybe, but I doubt it.

Did you run your Application.OnKey line within a procedure to trap the key-press combination? Can you show the whole procedure?

What does my_macro do? Is it spelled right; e.g. not mymacro?
Where is my_macro located?

[luv2glyd]

Hey AF,

Here's the file, the full code is:

Please Login or Register  to view this content.

I run "test" first to tie the keys to "my_macro" and then go and try pressing the shortcut keys.

shortcut test.xlsm

PS: trying "0" on the number pad here, which is {96}.

[AlphaFrog]

I couldn't get your code to work as well. I don't know why.

I did get this to work though.

Please Login or Register  to view this content.

Only the 97 (num lock on) keypress is in effect. But cycling through both seems to make a difference.

[luv2glyd]

Ok, thank you for taking a look - that works for me as well!