I found this code elsewhere in the net. This maybe the code that I am looking for.
The only issue with this code is when I click, let say C1 then it bounce to another cell. Is there anyway to when I click, it will stay in the cell.
Also, if you can add a yellow color in the cell as I press the tab?



Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Static intPrevPos As Integer
    Static boolAlreadyRun As Boolean
    Dim avarTabOrder As Variant
    Dim intPos As Integer
     
    avarTabOrder = Array("A1", "A2", "A3", "C1", "C2", "C3")
    If Not boolAlreadyRun Then
        intPrevPos = LBound(avarTabOrder)
        boolAlreadyRun = True
    End If
    
    Application.EnableEvents = False
    If Target.Cells.Count > 1 Then Set Target = ActiveCell
    If intPrevPos = UBound(avarTabOrder) Then intPrevPos = LBound(avarTabOrder) - 1
    If Target.Address <> avarTabOrder(intPrevPos + 1) Then _
    Me.Range(avarTabOrder(intPrevPos + 1)).Select
    intPrevPos = intPrevPos + 1
    Application.EnableEvents = True
End Sub
thanks.