Microsoft Office Forums - View Single Post - Excel VBA: Key Bindings?

Thread: Excel VBA: Key Bindings?

View Single Post

Old

10-15-2012, 04:25 AM

tinfanide

tinfanide is offline

tinfanide uses Windows 7 64bit

Windows 7 64bit tinfanide uses Office 2010 32bit

tinfanide uses Office 2010 32bit

Office 2010 32bit

Expert

The original poster

Join Date: Aug 2011

Posts: 312

tinfanide is on a distinguished road

Default

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

Reply With Quote