return to first column of next row

[DanO]

I am trying to make a worksheet with only seven columns. I configured excel
to move to the right after entering data into a cell. I need help creating an
auto return after the data is entered into the last column (G). Also, Is
there a way to have Excel display only the seven columns for the end-user? I
have looked for examples of code but I can not find what I need or make it
myself.

 

[Gord Dibben]

Hide the other columns.

Unlock cells in the 7 columns then protect the worksheet.

Use Tab key to move across and down.

Or set the ENTER key to move right.

Without protection...................

Hide the unneeded columns.

Start in A1 and Tab your way across as you enter data.

When leaving column G hit the ENTER key to move back to column A one row down.

 

[JP]

In addition to Gord's suggestion, how about some VBA code to simulate
a typewriter return?

This would go in the sheet module for the worksheet you are using.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If ActiveCell.Column = 8 Then ActiveCell.Offset(1, -7).Select
End Sub

See http://www.rondebruin.nl/code.htm if you need assistance
implementing.

HTH,
JP

 

[DanO]

Thanks for the code and link to help me get this working. It works prefect.

 

[JP]

Glad to hear it!


--JP

Thanks  for the code and link to help me get this working. It works prefect.