Hit "Enter", move to the right, not down

[Ikrion]

Every time I hit "Enter" I want it to move to the cell to the right, not immediately down as it is currently doing.

Ideally, it would start in column C, go to D, E, etc, and continue through I. Once you hit "Enter" in I, it would go to C in the next row below. Is this possible?

We will be using a barcode scanner to do this for each entry. I'm not sure if the scanner will automaticall include an "enter" command, but if not, is that something that can be programmed in as well? I'm not sure how to tell it when the cell is complete.

Thanks!

 

[kpark91]

Left Top Big MS Emblem thingy... > Excel Options > Advanced > Enter -> Move to Right

 

[Rick Rothstein]

To follow up on kpark91's posting... if you are using a version of Excel prior to XL2007, then click Tools/Options on the menu bar and select the Edit tab on the dialog box that appears, then select "Move selection after Enter" and change the direction in the drop-down to "Right".

 

[Ikrion]

That worked great, thanks!


So now that just leaves the other issue of how to get "enter" in column I to get it to return back to column C on the next rwo down, rather than just continuing over to the next column.

 

[jasonb75]

In the worksheet code module

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Target.Column > 9 Then Cells(Target.Row + 1, 3).Select
End Sub

 

[BarCodeWiz]

IKrion,

Most barcode scanners can be configured to terminate each scan with any character (usually Enter by default, but not always). If your scanner does not add it, you should be able to change the settings of the scanner by scanning a certain sequence of barcodes from your user manual.