tony.reynolds
Board Regular
- Joined
- Jul 8, 2010
- Messages
- 97
Hello all,
I have a user form that have a phone and a fax field that i dont want letters entered.
i have in my code
If Not IsNumeric(Phone.Value) Then
MsgBox "Phone number not valid"
Exit Sub
End If
But dosnt allow number with spaces
ideally the number format should only allow XX XXXX XXXX format
can someone help me write my code ?
I have a user form that have a phone and a fax field that i dont want letters entered.
i have in my code
If Not IsNumeric(Phone.Value) Then
MsgBox "Phone number not valid"
Exit Sub
End If
But dosnt allow number with spaces
ideally the number format should only allow XX XXXX XXXX format
can someone help me write my code ?