ISNumeric Function

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

Syntax

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:

Example 1:

Dim MyVar, MyCheck
MyVar = 53   ' Assign a value.
MyCheck = IsNumeric(MyVar)   
' Output: True.

Example 2:

MyVar = "459.95"   ' Assign a value.
MyCheck = IsNumeric(MyVar)  
' Output: True.

Example 3:

MyVar = "45 Help"   ' Assign a value.
MyCheck = IsNumeric(MyVar)   'Output: False

Example 4:

Dim MyVar, MyCheck
MyVar = CDate("2023-01-21" )  ' Assign a date
MyCheck = IsNumeric(MyVar)
'Output: False

Example 5:

MyVar = "3.14"   ' Assign a floating-point number as a string.
MyCheck = IsNumeric(MyVar)
'Output: True

Example 6:

MyVar = vbTrue   ' Assign a Boolean value.
MyCheck = IsNumeric(MyVar)   
'Output: True