Microsoft Office Forums - View Single Post

tinfanide · 10-15-2012, 05:07 AM

Quote:

Originally Posted by tinfanide

I've found some hints on the Internet, yet it doesn't work at all in my case:

http://vbadud.blogspot.hk/2007/06/assigning-shortcut-keys-excel-macros.html

Code:

Sub a()
Application.OnKey "^t", "b"
End Sub

Sub b()
MsgBox "b..."
End Sub

Book1.xlsm
I have just tested the codes.
It works with Procedure a() but not Procedure c().
Just can't figure out why.
Please tell me if ya know why. Thanks.