Userform textbox code to run after max length value is reached

[ipbr21054]

Hi,

I have a userform with Textbox 1-7
Each TextBox has a max length of 2 set & auto tab is also applied.

I am trying to run a code for when the 2 values are entered in textbox7 but it runs as soon as i enter 1 value

Example of what should happen
Enter two values in textbox1
Now textbox2 is selected
I enter the 2 values again
The code continues
When i reach textbox7 i wish to enter 2 value THEN the code should run BUT not until 2 values have been entered

Code in use

Private Sub TextBox7_Change()
If TextBox7.Value <> 2 Then
Call TransferValues_Click
End If
End Sub

 

[rabsofty]

Private Sub TextBox7_Change()
If Len(TextBox7) <> TextBox7.MaxLength Then Exit Sub
Call TransferValues_Click
End Sub

 

[rabsofty]

oops forgot to enter code correctly

Private Sub TextBox7_Change()
If Len(TextBox7) <> TextBox7.MaxLength Then Exit Sub
Call TransferValues_Click
End Sub

 

[ipbr21054]

Many thanks for the reply & now in use