Ok im a newb to vb soo forgive me if this is somestupid little error but everytime i use the code below it goes straight to the else option no matter what is entered in to the text box
Code:
If InStr(txtPhone, "7422323") > 4 Then 'When the text is greater than four exectue command below
        txtName = "Chris Henry"
        txtAddress1 = "243 Field Road"
        txtAddress2 = "Sheldon"
        txtTown = "Birmingham"
        txtPostCode = "B26 4ER"
        
Else
 
 MsgBox ("Instert Area Code") 'when the text is 3 or lower this message bx will display

        

        
End If