ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,224
- Office Version
- 2007
- Platform
- Windows
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
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
Rich (BB code):
Private Sub TextBox7_Change()
If TextBox7.Value <> 2 Then
Call TransferValues_Click
End If
End Sub