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
> >
> >
> >