| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Editing Number Input on a User Form
When editing input on a user form there is an IsDate function. But no
companion IsNumber. If I use the WorksheetFunction.IsNumber it sees the input from the form as a string, and even when a valid number it says it isn't. What is a way to check that the user entered a valid number? Don <donwiss at panix.com. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Editing Number Input on a User Form
Maybe:
if isnumeric().... Don Wiss wrote: When editing input on a user form there is an IsDate function. But no companion IsNumber. If I use the WorksheetFunction.IsNumber it sees the input from the form as a string, and even when a valid number it says it isn't. What is a way to check that the user entered a valid number? Don <donwiss at panix.com. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| input in number form is being multiplied by 1000 when i input. | Excel Discussion (Misc queries) | |||
| How to input file name in user form | Excel Programming | |||
| Trouble with editing data from a user form | Excel Programming | |||
| User Input Form | Excel Programming | |||
| Help with a User Input Form | Excel Programming | |||
Linear Mode
