Editing Number Input on a User Form

  • Thread starter Thread starter Don Wiss
  • Start date Start date
D

Don Wiss

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>.
 
Maybe:

if isnumeric()....



Don said:
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>.
Click to expand...
 
Back
Top