Determines if a variant can be evaluated as a number.
The required Exp argument is a variant containing a numeric expression or string expression that can be evaluated as a number.
IsNumeric returns False if Exp is a date expression.
Syntax
IsNumeric(Exp)
Exp
A valid string, number or Variant containing a value recognizable as a string or number.
Return Value
Returns a Boolean True or False.
Related Functions
IsDate | IsEmpty | IsNull | VarType
Example
Dim TestVar ' Declare variable.
TestVar = InputBox("Please enter a number, letter, or symbol.")
If IsNumeric(TestVar) Then ' Evaluate variable.
MsgBox "Entered data is numeric." ' Message if number.
Else
MsgBox "Entered data is not numeric." ' Message if not.
End If
Published June 2018