Posted to microsoft.public.excel.programming

will

external usenet poster

Posts: 11

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 With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
shortcut has change or move so this shortcut can not open	bakerstreet	Excel Worksheet Functions	2	April 2nd 10 01:21 PM
split post code (zip code) out of cell that includes full address	Concord	Excel Discussion (Misc queries)	4	October 15th 09 06:59 PM
macro code shortcut	Brian	Excel Worksheet Functions	4	December 15th 04 08:59 PM
Delete Shortcut with Code	zSplash	Excel Programming	9	April 10th 04 06:55 PM
Disabling the CONTROL + BREAK shortcut key function - HAVING PROBLEM - MY CODE DOES NOT WORK	Marcello do Guzman	Excel Programming	0	January 15th 04 02:41 AM

All times are GMT +1. The time now is 11:13 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us