Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vba problem with isnumeric | Excel Programming | |||
opposite of IsNumeric | Excel Discussion (Misc queries) | |||
opposite of IsNumeric | Excel Programming | |||
IsNumeric Test | Excel Programming | |||
Not IsNumeric not working - or is it me? | Excel Programming |