Data Entry Cells

  • Thread starter Thread starter Kindlysinful
  • Start date Start date
K

Kindlysinful

Hello,
I have office 2004 for Mac and am trying to make it so that when you get to
the end of the row of data entry and hit enter the next active cell is the
first one that you started with.
IE: cells a1, b1, c1, d1, e1, f1... are data entry cells and what I would
like is when the last data point was entered into f1 and "enter" was hit,
excel would automatically return to a1.

Thanks,
Scott
 
You can use a worksheet change macro like the one below

Private Sub worksheet_Change(ByVal target As Range)

If target.Column = 6 Then
Cells(target.Row + 1, "A").Select
End If

End Sub
 
Scott or Kindlysinful -

If you select the range first, e.g., A1:F5 for five rows of data, then after
you type in a cell, you can use the Tab key (instead of the Return key) to
move to the next cell in the selected range. For the A1:F5 example, when you
are in cell F1 and press the Tab key, the active cell becomes A2.

For Mac-specific questions (unlike this one), consider the very active
microsoft.public.mac.office.excel newsgroup.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel
 
Back
Top