Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Textbox Data IsNumeric
I guess we all know that IsNumeric does not work 100% of the time when used
with Userform Textboxes. This is the format that I am looking for from the users #####-# or ADT##-#. How can I ensure I have this format? This is what I have so far: ' must have correct Item # to apply to schedule If Len(tbxItemNumber) < 7 Then strPrompt = "You must have a correct Item # to continue. It must be " & _ "in this format: ''#####-#''" intButtons = vbCritical MsgBox strPrompt, intButtons, strTitle DataValidator = True Exit Function End If -- Cheers, Ryan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Textbox data to Textbox in Other File | Excel Programming | |||
isnumeric() and hyphen | Excel Programming | |||
Isnumeric | Excel Programming | |||
opposite of IsNumeric | Excel Programming | |||
Not IsNumeric not working - or is it me? | Excel Programming |