Running macro on any key pressed event.

[Premanshu]

Hi,

Can anyone please advice me how to make a code so that it captures the event of pressing any key of the keyboard and triggers a macro.

I tried using OnKey method but the problem with this is I am getting stick to any particular button whichever i specify in the onkey method wheareas I want to keep it general for any button in the keyboard.

Also if anyone can suggest how can I use OnKey method to use the "S" key to launch a macro.


Please help

Regards,
Premanshu.

 

[RoryA]

I haven't said how to do it - I was asking whether it would work for you first!

 

[Premanshu]

> hmm sorry rorya.... I could not understand it.... As of now I am not too much sure about but yes I want to go ahead with it.... it seems to be the right thing I am searching for.....

Also request you to please ignore if I ask something stupid .. as I told you I am not very much versed with vba.

Thank you so much Rorya for your help and advice in advance >