IsNumber "Sub or function not defined"

[Glory]

IsNumber is listed in VBA's help as one of the "worksheet functions available to VBA", but when I try to use it, an error message appears.

What code do I use to determine whether a string contains one type of data or another?

 

[shg]

The VBA native IsNumeric function will tell you if a string can be converted to a number.

To use IsNumber (which does not tell you the same thing), you need to apply as WorksheetFunction.IsNumber

 

[Glory]

Is that what i want to use in order to check to make sure that a user has inserted the right kind of information in a field?

I want to check to see whether a date actually consists of numbers or if the user has accidentally inserted a letter. I'm going to split the date at the delimiters and use "IsNumeric"?

What if I needed to make sure it was a bunch of letters?

 

[Glory]

Also, what does it mean to say that a "worksheet function" is "available to VBA", if not that those functions can be used in VBA?

 

[shg]

The native IsDate function will tell you if a string can be converted to a date and/or time.

 

[shg]

Also, what does it mean to say that a "worksheet function" is "available to VBA", if not that those functions can be used in VBA?

They can be used, Glory, but you need to preface it:

mySum = WorksheetFunction.Sum(Range("A1:A10").Value)
 
mySum = WorksheetFunction.Sum(myArray)

 

[Glory]

Oh, gotcha.

Thanks