Isnumeric
 

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

Isnumeric
 

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

Isnumeric
 

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

Isnumeric
 

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