IsNumeric function
Summary
True if expression numeric.
Syntax
IsNumeric(expression)
The required expression argument is a Variant containing a numeric expression or a string expression.
Example
Example
This example uses the IsNumeric function to determine if a variable can be evaluated as a number.
Dim MyVar, MyCheck
MyVar = "53" ' Assign value.
MyCheck = IsNumeric(MyVar) ' Returns True.
MyVar = "459.95" ' Assign value.
MyCheck = IsNumeric(MyVar) ' Returns True.
MyVar = "45 Help" ' Assign value.
MyCheck = IsNumeric(MyVar) ' Returns False.
This example uses the IsNumeric function to determine if a variable can be evaluated as a number.
Dim MyVar, MyCheck
MyVar = "53" ' Assign value.
MyCheck = IsNumeric(MyVar) ' Returns True.
MyVar = "459.95" ' Assign value.
MyCheck = IsNumeric(MyVar) ' Returns True.
MyVar = "45 Help" ' Assign value.
MyCheck = IsNumeric(MyVar) ' Returns False.