ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Assign shortleys to macro (https://www.excelbanter.com/excel-programming/420705-assign-shortleys-macro.html)

BOSS

Assign shortleys to macro
 
Hi,

With the help of this forum i got a nice code to assign short Key to a macro.

Application.OnKey "^1", "macro"

But this does not work for the numeric keypad.

Please help me so that i can assign Ctrl 0 to Ctrl 9 to ten different macros
using numeric keypad.

I also wish that the numpad should be on.

Like i got for three keys

"^{97}" for CTRL-1
"^{100}" for CTRL-4
"^{104}" for CTRL-8

Thanks!

Boss


All times are GMT +1. The time now is 12:12 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com