IsNumeric

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