| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I should know this but ...
How can I invoke a VBA subroutine from a spreadsheet keypress such as
Alt+RightArrow? Thanks, Keith |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
