Auto enter when 3 digits in a text box

[stuartchaffey]

Hey,

this is probably so simple but i can not get my head round it.

I want enter to initiate when textbox1 has 3 digits in it, this is just so i dont have to press enter each time to move to the next textbox.

any help greatly appreciated

 

[mohadin]

Hi try

Private Sub TextBox1_Change()
If Len(TextBox1.Value) = 3 Then TextBox2.SetFocus
End Sub

 

[stuartchaffey]

Perfect, thank you

 

[dmt32]

I want enter to initiate when textbox1 has 3 digits in it, this is just so i dont have to press enter each time to move to the next textbox.

Appreciate you have a solution but just for future reference you can do what you want without VBA. If you go to the controls properties, set the AutoTab property for your TextBox to True and then enter the character MaxLenght for the control.

Doing this should, once a user has entered the maximum number of characters, automatically move the focus to the next control specified in the tab order.

Hope Helpful

Dave

 

[mohadin]

You are very welcome
Thank you for the feedback
Be happy and safe
would be good to read dmt32's solution as well.
Best regards