Visual Basic for Applications Reference

IsNumeric Function

See Also Example Specifics

Returns a Boolean value indicating whether an expression can be evaluated as a number.



The required expressionargument is a Variant containing a numeric expression or string expression.


IsNumeric returns True if the entire expression is recognized as a number; otherwise, it returns False.

IsNumeric returns False if expression is a date expression.