auto advance of textboxes

[scott micklo]

Hey there. I must be missing something with this code.
On a userform, I am attempting to be in a textbox called txtPTagLtr. When 1 character is input (can be anything) it will automatically advance to the next text box called intPTagNo.

Here is Select Code copy to clipboard
Private Sub txtPTagLtr_Change()


'whenever there is 1 character registered in the TextBox

If txtPTagLtr.TextLength > 0 Then NOTE: I tried = 1 and it still didnt work

'select (SetFocus) the next TextBox

intPTagNo.SetFocus

End If


End Sub[/CODE]
I have even gone so far as to go into the textbox properties of txtPTagLtr and change max length to 1; auto tab to True. If I look at the tab index positions, the textbox txtPTagLtr is 2, and the intPTagNo is 3.


Any ideas why it wont automatically advance when a character is input?

[gmr4evr1]

I tried it both ways, and it worked. Is the name of the txtPTageLTr text box correct?

[scott micklo]

Yes. I actually copy/pasted it into the code, and the same with this post.
Would it have anything to do with it going from a txt textbox to an int textbox?

Would it possibly help to cut those 2 text boxes out and try again?

[Norie]

Scott

There's only one type of textbox and the only input they take are text.

Can you upload a sample workbook with a userform that demonstrates the problem?

[scott micklo]

I am not sure what happened. I cut them both out, and remade them. And now it works. Doesn't make sense/.
Thanks for your assistance

[gmr4evr1]

Glad you were able to figure it out.