Private Sub Text1_Change(Index As Integer)
If Len(Text1(Index).Text) >= 5 Then
If (Index + 1) > 19 Then Index = -1
Text1(Index + 1).SetFocus
End If
End Sub
Private Sub Text1_Change(Index As Integer)
With Text1(Index)
If Len(.Text) >= 5 Then
.Text = Left$(.Text, 5)
With Text1
Text1(IIf(Index = .UBound, .LBound, Index + 1)).SetFocus
End With
End If
End With
End Sub