return key...

[AndyD]

hi
Ive changed my settings so when press return (or enter) excel moves to cell to right instead of down..

ive 2 columns (B & C)...ideally what i would like is something like

enter details in B19, excel moves to right C19, excel then moves to B20, then to C20 etc

is this possible?

cheers all
Andy

 

[Juan Pablo González]

Select columns B and C, and then, start entering the information.

 

[jimboy]

Right mouse over the sheet name (i.e. Sheet1) and select view code, then paste this in;

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
If Target.Column = 3 Then Target.Offset(1, -1).Select

End Sub

 

[AndyD]

Hi Jimboy
thanks for this...sorry am being a bit thick i think..ive done as you suggested but it doesnot seem to work...pressing enter, or return just moves cells to right each time...

any ideas for me?
thanks
Andy

 

[jimboy]

It will work when you change a cell in column C, if you what it to run when you change selection use this;

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
If Target.Column = 4 Then Target.Offset(1, -2).Select

End Sub

 

[Juan Pablo González]

Did you try what I suggested ??

 

[AndyD]

i did but i didnt put info in (Doh!) just pressed enter....
thanks again, have great w/e
Andy

 

[Chitosunday]

Private Sub Worksheet_Change(ByVal Target As Range)
If ActiveCell.Column >= 4 Then
Cells(ActiveCell.Row + 1, 2).Select
end if
End Sub