sendtoanurag wrote:Put this code for validation
If Text1 Like "###.###.##.#." Then
'Do ur work
Else
Text1.setFocus
Alert User
End If
'# for numbers
thanks alot mate the code somehow works but there is one hitch, i can only enter an IP address that has 3 values througout. eg 123.456.678.901
What if the IP address is something like 123.34.456.4.
the IP addresses vary but your code is only allows one way of entering them.
all in all thanks alot partner, atleast now i have a clue so modifing the code wont be very difficult