I would like anytime I'm in Exel to be able to hit CRTL ALT ~ and call the
function testmsg.

Here is what I have:
Application.OnKey "^%{~}", "testmsg"

Does this look right?
I just put this in a new module but it is not picking up the key press.
Am I doing something wrong?