I should know this but ...

How can I invoke a VBA subroutine from a spreadsheet keypress such as
Alt+RightArrow?

Thanks,

Keith

Hello Keith,

A list of available Subs is shown in the Macro list dialog. Press ALT + F8 to bring it up in Exce. Select the Sub you want to assign a hot key to and click "Options" on the bottom right. This will allow you to asssign a CTRL + some key to the macro.

Sincerely,
Leith Ross

Keith,
Look at the "OnKey" method in VBA help.
Jim Cone
San Francisco, USA


"keithb" <[email protected]>
wrote in message
news:[email protected]
How can I invoke a VBA subroutine from a spreadsheet keypress such as
Alt+RightArrow?
Thanks,
Keith

Hi Keith,
Open the workbook with the macro attached.
Go to Tools > Macro > Macros...
Select the macro you want to invoke and then go to Options...
HTH

--
Ken Hudson


"keithb" wrote:

> How can I invoke a VBA subroutine from a spreadsheet keypress such as
> Alt+RightArrow?
>
> Thanks,
>
> Keith
>
>
>