TextBox Issue

[zyhin]

Hi all,

I have a userform with 2 text boxes, one is limited to 4 numbers and the other 2. Is there anyway to get the text box to automatically goto the second text box once you put you first 4 numbers in. I would like this to work like most progams when you enter serial codes.

Thank

Z

 

[Ruddles]

Let's assume your text boxes are called TextBox1 and TextBox2. Right-click TextBox1 in design mode and select View Code. From the two dropdowns select TextBox1 and Change.

VBA will provide the lines in blue - you just add the line in red:-

[COLOR=blue]Private Sub TextBox1_Change()[/COLOR]
 
[COLOR=red]  If Len(TextBox1) = 4 Then TextBox2.SetFocus[/COLOR]
 
[COLOR=blue]End Sub[/COLOR]

If your text boxes aren't called TextBox1 and TextBox2, modify the code accordingly.

 

[gregtx81]

Ditto!

 

[zyhin]

Thank you very much...Cant believe how simple that is.