ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,226
- Office Version
- 2007
- Platform
- Windows
Hi,
I have a userform where there are many Textboxes etc.
I currently have this in use & works fine.
I wish to change the way it now works in that it will only enter the TextBox4 value IF TextBox1 has the name KELVIN GOH present
The name KELVIN GOH will always have a 3 or 4 number after it but need to just look at the name.
Example on how it should work.
If TextBox1 value = KELVIN GOH ??? & OptionButton14.Value = True Then
TextBox4.Value = 15976627
If TextBox1 value is another name then disregard the rest
I have a userform where there are many Textboxes etc.
I currently have this in use & works fine.
Rich (BB code):
Private Sub OptionButton14_Click()
If OptionButton14.Value = True Then
TextBox4.Value = 15976627
End If
End Sub
I wish to change the way it now works in that it will only enter the TextBox4 value IF TextBox1 has the name KELVIN GOH present
The name KELVIN GOH will always have a 3 or 4 number after it but need to just look at the name.
Example on how it should work.
If TextBox1 value = KELVIN GOH ??? & OptionButton14.Value = True Then
TextBox4.Value = 15976627
If TextBox1 value is another name then disregard the rest