ExcelBanter - Trigger Macro with keystroke

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Trigger Macro with keystroke (https://www.excelbanter.com/excel-programming/426505-trigger-macro-keystroke.html)

Trigger Macro with keystroke

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

Trigger Macro with keystroke

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

"VJ" wrote:

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

Trigger Macro with keystroke

Thanks Jeff.

"Jeff" wrote:

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

"VJ" wrote:

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

All times are GMT +1. The time now is 08:48 AM.