Curser Movement control

[G Lam]

Hi, Usually, when I press tab, the curser will move to the next cell on the
right. If I press enter, the curser will move down one row on the same
column.
How can I, say, move the curser 5 cells to the right when I press Tab key or
Enter Key?
Thank You.
GL

 

[RagDyeR]

One way to explicitly control the exact "next cell of focus" selection, is
to select the cells in the desired order of travel, and then preserve this
ordered movement by creating a named range.

This old post describes the steps that can be taken to create such a "named
range".

http://tinyurl.com/39vzv


--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Hi, Usually, when I press tab, the curser will move to the next cell on the
right. If I press enter, the curser will move down one row on the same
column.
How can I, say, move the curser 5 cells to the right when I press Tab key or
Enter Key?
Thank You.
GL

 

[Ron de Bruin]

Hi GL

You can use a macro
You must run the onkey sub each time you open the workbook
Use the workbook open event to do this

See Chip Pearson his page about events
http://www.cpearson.com/excel/events.htm


Sub test()
' To restore use this
'Application.OnKey "{TAB}"

Application.OnKey "{TAB}", "yourmacro"
End Sub


Sub yourmacro()
ActiveCell.Offset(0, 5).Select
End Sub