What else am I leaving out, still won't reconize just numbers
If Not IsNumeric(TextBox1.Text) Then
MsgBox "Units Must Be Numeric.", vbExclamation, "Floater Holidays"
Exit Sub
End If

recognises numbers here. What are you inputting?

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Richard" wrote in message
...
What else am I leaving out, still won't reconize just numbers
If Not IsNumeric(TextBox1.Text) Then
MsgBox "Units Must Be Numeric.", vbExclamation, "Floater Holidays"
Exit Sub
End If

I tested it by inputing letters and it still took them

"Bob Phillips" wrote:

recognises numbers here. What are you inputting?

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Richard" wrote in message
...
What else am I leaving out, still won't reconize just numbers
If Not IsNumeric(TextBox1.Text) Then
MsgBox "Units Must Be Numeric.", vbExclamation, "Floater Holidays"
Exit Sub
End If

If I put any text in, I get the error message

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Richard" wrote in message
...
I tested it by inputing letters and it still took them

"Bob Phillips" wrote:

recognises numbers here. What are you inputting?

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Richard" wrote in message
...
What else am I leaving out, still won't reconize just numbers
If Not IsNumeric(TextBox1.Text) Then
MsgBox "Units Must Be Numeric.", vbExclamation, "Floater Holidays"
Exit Sub
End If