IsNumeric Function 

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

IsNumeric(expression)

Remarks

The expression argument can be any 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.

The following example uses the IsNumeric function to determine whether a variable can be evaluated as a number:

Dim MyVar, MyCheck

MyVar = 53   ' Assign a value.

MyCheck = IsNumeric(MyVar)   ' Returns True.

MyVar = "459.95"   ' Assign a value.

MyCheck = IsNumeric(MyVar)   ' Returns True.

MyVar = "45 Help"   ' Assign a value.

MyCheck = IsNumeric(MyVar)   ' Returns False.

Requirements

Version 1

See Also

Reference

IsArray Function
IsDate Function
IsEmpty Function
IsNull Function
IsObject Function
VarType Function