Trigger Macro with keystroke

[VJ]

Hi,

I have a macro (ex: Foo).

I want to run this macro with the keystrokes (Shift+Ctrl+F12) keys.

Is this possible to do this?

Thanks in advance for your help.

Regards,

VS

 

[Jeff]

Sub Test()
Application.OnKey "^+{F12}", "Foo"
End Sub

 

[VJ]

Thanks Jeff.

Sub Test()
Application.OnKey "^+{F12}", "Foo"
End Sub