I should know this but ...
 

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

Thanks,

Keith

I should know this but ...
 

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


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=494273

I should know this but ...
 

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


"keithb"
wrote in message

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

I should know this but ...
 

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