Private Sub TextBox1_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger)
If Len(TextBox1.Value) = 4 Then
KeyAscii = 0
TextBox2.SetFocus
End If
End Sub
Private Sub TextBox1_Change()
If Len(TextBox1.Value) > 3 Then TextBox2.SetFocus
End Sub
Private Sub TextBox1_Change()
If Len(TextBox1) > 3 Then
TextBox1 = Left(TextBox1, 4)
TextBox2.SetFocus
End If
End Sub