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

recognises numbers here. What are you inputting?

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Richard" <Richard@discussions.microsoft.com> wrote in message
news:71F4FA79-4C05-4577-90F1-5DAC5B1D116A@microsoft.com...
> 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" <Richard@discussions.microsoft.com> wrote in message
> news:71F4FA79-4C05-4577-90F1-5DAC5B1D116A@microsoft.com...
> > 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" <Richard@discussions.microsoft.com> wrote in message
news:DF9DC05B-98E5-4B85-B7D6-3EC760DC3059@microsoft.com...
> 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" <Richard@discussions.microsoft.com> wrote in message
> > news:71F4FA79-4C05-4577-90F1-5DAC5B1D116A@microsoft.com...
> > > 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
> >
> >
> >