If Then advice for value to be entered in textbox

[ipbr21054]

Hi,

I have a userform where there are many Textboxes etc.

I currently have this in use & works fine.

        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

 

[dmt32]

most welcome - glad we could help & appreciate your feedback

Dave