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"
But dosnt allow number with spaces
ideally the number format should...