Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with shortcut key code
I have created a bunch of macros and want to assign shortcut keys to
them using code instead of the tools option method since you have to assign to a letter using that method. I have a bunch of subs that are very basic and work when I use F5. To assign macros I created the following code in the same module as the subs. Public Sub Workbook_Open() With Application .OnKey key:="+^{$}", procedu="fmtDollar" .OnKey key:="+^{%}", procedu="fmtPercent" .OnKey key:="+^{!}", procedu="fmtComma" .OnKey key:="+^{~}", procedu="fmtGeneral" End With End Sub I cannot for the life of me figure out why the subs won't fire using ctrl+shift+4, ctrl+shift+5 etc... Any help is greatly appreciated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with shortcut key code
I assume the use of the ":=" is a typo because the
compiler should have choked on this. To get numbers to work leave them outside of the curly brackets:- Sub OnKey() Application.OnKey "^+4", "TestOnKey" End Sub Sub TestOnKey() MsgBox "OnKey worked !!!" End Sub Regards, Greg |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with shortcut key code
That seemed to work. Thanks.
"Greg Wilson" wrote in message ... I assume the use of the ":=" is a typo because the compiler should have choked on this. To get numbers to work leave them outside of the curly brackets:- Sub OnKey() Application.OnKey "^+4", "TestOnKey" End Sub Sub TestOnKey() MsgBox "OnKey worked !!!" End Sub Regards, Greg |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
shortcut has change or move so this shortcut can not open | Excel Worksheet Functions | |||
split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
macro code shortcut | Excel Worksheet Functions | |||
Delete Shortcut with Code | Excel Programming | |||
Disabling the CONTROL + BREAK shortcut key function - HAVING PROBLEM - MY CODE DOES NOT WORK | Excel Programming |