Tabs Jumping

[art]

Hello:

How can I make a userform with some text boxes where the user enters some
text and when the text max is up it should jump tp the next tab. For E.G. if
the first tab maxLength is 5 and the user had entered already 5 letters, it
should jump to the next tab?

Thanks

 

[art]

Thanks. Lets say I have Textbox2 what should I write to jump?
GoTo textbox2?

 

[Susan]

If Len(Texbox1.Value) = 5 Then
Textbox2.SetFocus

try that

susan

 

[art]

Thanks.

If Len(Texbox1.Value) = 5 Then
Textbox2.SetFocus

try that

susan