Cindi
A macro like the one below will do what you want. You will have to fill
in the macro for all your data entry cells. Here's how:
Look at the 2 lines :
Case "A1": Range("C3").Select
Case "G2": Range("H5").Select
This says if the user enters something in A1, the active cell will jump to
C3. If he enters something in G2, the active cell jumps to H5. Change
these as needed, then add as many similar lines as you need.
Also, as written, you have to name the range of all the data entry cells. I
chose the name "AllEntryCells". Change this as you wish. Post back if you
need more.
This is a sheet event macro and must be placed in the sheet module of your
sheet. To access that module, right-click on the sheet tab and select View
Code. Paste this macro into that module. "X" out of the module to return
to your sheet. HTH Otto
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count 1 Then Exit Sub
If IsEmpty(Target.Value) Then Exit Sub
If Not Intersect(Target, Range("AllEntryCells")) Is Nothing Then
Select Case Target.Address(0, 0)
Case "A1": Range("C3").Select
Case "G2": Range("H5").Select
'Etc
'Etc
'Etc
End Select
End If
End Sub

"Cindi" wrote in message
...
I am trying to creat a form so that when the person filling it out
completes
a cell, I can direct which cell they go to next. Is that possible?

I have locked the cells they cannot change, but tabbing through it, I get
stuck in a circle in a couple of places.