On second thought I need a little more help.
Protecting the sheet and unprotecting cells doesn't do it since the tab
order doesn't mesh with left to right top to bottom on my form. The link that
has the change function looks like it would be perfect but I couldn't get it
to work. Here's the code from the link below. I copied this into a module in
my spreadsheet. It doesn't seem to execute at all. Not sure if the module is
wrong, or more likely how I put it into my excel spreadsheet in the modules
that is wrong. Any additional assistance would be appreciated.
Jeff

Private Sub Worksheet_Change(ByVal Target As Range)

Dim aTabOrder As Variant
Dim i As Long

€˜Set the tab order of input cells
aTabOrder = Array(€�A1€³, €œC1€³, €œG3€³, €œB5€³, €œE1€³, €œF4€³)

€˜Loop through the array of cell address
For i = LBound(aTabOrder) To UBound(aTabOrder)
€˜If the changed cell is in the array
If aTabOrder(i) = Target.Address(0, 0) Then
€˜If the changed cell is the last array element
If i = UBound(aTabOrder) Then
€˜Select the first cell in the array
Me.Range(aTabOrder(LBound(aTabOrder))).Select
Else
€˜Select the next cell in the array
Me.Range(aTabOrder(i + 1)).Select
End If
End If
Next i

End Sub













"Jeff" wrote:

Thanks,
I used the link you provided and that's exactly what I needed.
Thanks

"Dick Kusleika" wrote:

Jeff

If you unlock those cells and protect the sheet, then you can tab from
unprotected cell to unprotected cell. Enter still doesn't work like that,
though.

If that isn't something you want to do, try this
http://www.dicks-blog.com/archives/2...rder-of-cells/

--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com

Jeff wrote:
How do I make a macro force my spreadsheet to jump to the next cell
after I hit enter. For ex If i'm in cell a2 and I hit enter I want
my cursor to go to b5. After I hit enter when I'm in b5 I want the
cursor to go to c7 etc etc? Thanks
Jeff