Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to program a key, say F4?
I have a huge spreadsheet in Excel 2002 and needs to jump from predefined
rows alot. I would like to know if there is a way to program a key, say F4, so the cursor box will go all the way to the row 1 of the spread sheet. Secondly, is there a way to program that key so it will jump to row 2000 and then row 10000? Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to program a key, say F4?
Jonathan,
First, create macros that will do what you want to do. Then, assign those macros to function keys using the OnKey method. E.g., Sub GoToRow1() Application.Goto ActiveCell.EntireColumn.Cells(1, 1), True End Sub Sub InitKey() Application.OnKey "{F4}","GoToRow1" End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel www.cpearson.com "Jonathan Lee" wrote in message ... I have a huge spreadsheet in Excel 2002 and needs to jump from predefined rows alot. I would like to know if there is a way to program a key, say F4, so the cursor box will go all the way to the row 1 of the spread sheet. Secondly, is there a way to program that key so it will jump to row 2000 and then row 10000? Thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to program a key, say F4?
Thanks Chip. I'll try that.
Jon. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a way to unload the loaded XLL file in Excel? Hi all, I amdebugging XLL link library using Visual C++. Everytime I rebuild the XLL, Ihave to close the whole Excel program and relaunch the Excel program again,and then load in the newly gene | Excel Discussion (Misc queries) | |||
Help with Program | Excel Worksheet Functions | |||
get value from another program | New Users to Excel | |||
Which program? | Excel Discussion (Misc queries) | |||
IF () program | Excel Discussion (Misc queries) |