Look in Excel VBA help at the OnKey method.

--
Regards,
Tom Ogilvy

"cottage6" wrote in message
...
I know you can assign a shortcut key to a macro you're recording, but how
can
you assign a key to one you've created in the VB Editor?