Private Sub txtFields_GotFocus(Index As Integer)
txtFields(Index).SelStart = 0
txtFields(Index).SelLength = Len(txtFields(Index))
End Sub
Private Sub txtFields_KeyDown(Index As Integer, KeyCode As Integer, Shift As Integer)
If KeyCode = vbKeyDown Then
If Index = txtFields.Count - 1 Then
txtFields(0).SetFocus
Else
txtFields(Index + 1).SetFocus
End If
ElseIf KeyCode = vbKeyUp Then
If Index = 0 Then
txtFields(txtFields.Count - 1).SetFocus
Else
txtFields(Index - 1).SetFocus
End If
End If
End Sub