View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Don Wiss Don Wiss is offline
external usenet poster
 
Posts: 300
Default Editing Numbers on a Form

When editing user input on a 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 simple way to check that the user entered a valid number?

Don <donwiss at panix.com.