I have a bit of code that tells the user that only numbers are allowed
in this textbox after they put in a letter, I ammended it to also allow
nothing as it was flagging up when nothing was entered.
How do i make it so i can have say a telephone number with a space or 2
in it?


Private Sub TextBox9_Exit(ByVal Cancel As MSForms.ReturnBoolean)
If IsNumeric(TextBox9.Value) = True Or TextBox9.Value = "" _ Then
Else
MsgBox "This box must only contain numbers!", vbInformation
TextBox9.Value = ""
Exit Sub
End If
End Sub

Thanks for looking
CAA


---
Message posted from http://www.ExcelForum.com/