Cursor movement upon an event

[Guest]

Lets say I have a worksheet with columns from A-G, when I enter a value into
column G I would like the cursor to move down 1 row and return to column B.
this would speed up my ability to enter my data in.

 

[Guest]

Select columns A:G and then do you entry using the enter key or the tab key.
If the enter key does move right, then change it under tools->Options->Edit
tab under Move Selection after Enter

You can write a macro to do it, but seems like overkill to me if you can
exercise a little discipline.

 

[paul.robinson]

Hi
Go into Tools, Macros, Visual Basic Editor. In the Project Explorer
Window on the left look for your excel file and double click the sheet
name where you want to enter data. In the blank code module that
appears paste this:

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Range("G:G"), Target) Is Nothing Then
Target.Offset(1, -5).Activate
End If
End Sub

regards
Paul

 

[Guest]

Private Sub Worksheet_Change(ByVal Target As Range)
Set r = Range("G:G")
If Intersect(Target, r) Is Nothing Then Exit Sub
Cells(Target.Row + 1, "B").Select
End Sub

This is worksheet code and must be pasted in the worksheet code area, not a
standard module.