Hot Key

  • Thread starter Thread starter George A. Yorks
  • Start date Start date
G

George A. Yorks

Within excel is it possible to setup a key to perform a
series of funtions ie: home,down arrow,right arrow.Example
my last number is placed in cell j10. I can get back to
b3, to begin entering numbers by using these three key
strokes can one key be set up to perform these three steps
 
Maybe you can use this??

You can select b3:J10
And start filling in the cells
If you press Enter in J10 you will jump to B3 again

If not give more information
 
Hi George,

You can use the macro recorder to do this very easily.
Although I am not well versed in writing VBA code, the
macro recorder was designed to do just these types of
things for the benefit of us non-programmers. For example,
if you want a macro that returns the cursor to B3 from
anywhere on the sheet and have it assigned to a hot key
follow these steps:

1. Put the cursor on any cell except B3.

2. Goto the Tools menu and select Macro>Record New Macro.
In the dialog that opens you can select a name for the
macro if you want or use the default. Enter a shortcut
key. This will be the hotkey combo that you want. For your
purposes you can leave the other fields as they are.
Select OK. The recorder is now set to record your
keystrokes. The stop recording toolbar should appear.

3. Select cell B3.

4. Stop the recorder by clicking the blue button on the
stop recording toolbar.

That's it! Now if you're in cell J10 just hit the hotkey
combo and the cursor will goto B3.

This is the code generated by the recorder. I named the
macro Home and assigned it to the key combo CTRL+Q:

Sub Home()
'
' Home Macro
' Macro recorded 9/22/2003 by
'
' Keyboard Shortcut: Ctrl+q
'
Range("B3").Select
End Sub

Hope this helps
Biff
 
Back
Top