OnKey VBA

[KlausW]

Hello
I have a challenge, I'm looking for a VBA code that can run a macro when I press a key, for example Ctrl and +.
I found this here on the forum but can't get it to work.
Some who can help.
Any help will be appreciated
Best Regards
Klaus W

Sub Test()

    Application.OnKey "^{+}", "TestProc"

End Sub

Sub TestProc()
    
    MsgBox "Hello"

End Sub

 

[RoryA]

If you are using the plus key on the number pad, you need:

Application.OnKey "^{107}", "TestProc"

 

[KlausW]

Sorry to say, if I put the code in the sheet and run it. It do like in the picture and if I put the code in a Module it is the same result. It's in Danish, but I hope you understand.

 

[RoryA]

I assume you actually ran the Test routine? Which + symbol are you using?

 

[KlausW]

Yes I did, I use + on the Numeric Key and CTRL and + nothing works