VBa to tab to the cells i want

[tonywatsonhelp]

Hi everyone,
not sure if this is possible but i need my sheet to keep the tab and enter keys from moving data into the wrong cells

heres what i need

E8 goes to G8 goes to E11 goes to G11 goes to E14 goes to E8

p.s. The sheet is page protected and all other cells in the range of E8:G14 are locked

so basically if someone adds data into any of the above cells, it locks them into that loop, so tab or enter keys move then to the desired next cell
if they select cells outside of this range then it should just behave as normal.

 

[offthelip]

put this in the worksheet code:

Private Sub Worksheet_Change(ByVal Target As Range)
seq = Array("$E$8", "$G$8", "$E$11", "$G$11", "$E$14")
For i = 0 To 4
    If Target.Address = seq(i) Then
        If i < 4 Then
        Range(seq(i + 1)).Select
        Else
        Range(seq(0)).Select
        End If
        Exit For
    End If
Next i
End Sub

 

[tonywatsonhelp]

This is brilliant
Thank you offthelip
Tony