submit then reset userform when max length is met

[drc2265]

Hello,

I currently have:

Private Sub textbox1_change()
If Len(TextBox1.Text) = 3 Then
TextBox3.SetFocus
End If
End Sub

Once max length on last textbox is reached, I would like the form to submit automatically without clicking command button, and then to reset the form with a setfocus of textbox 1.

I appreciate any help.

Thanks,
DC

 

[My Aswer Is This]

You said:

Once max length on last textbox is reached, I would like the form to submit ​

What does submit mean?

And do all textboxes have a maximum length of three.

So when Textbox1 text length=3 then set focus on Textbox2 and so on and so on for each Textbox and when the Textbox14=3 Submit. Is that what you want?

And again. What does Submit mean?

And your subject title says:

then reset userform​

What does reset mean?