is numeric function in vba code example
Example: how to check is the value enterd is a number or text in vba
If IsNumeric(Value) = True Then
MsgBox "The value is numeric"
Else
MsgBox "The value is not numeric"
End If
If IsNumeric(Value) = True Then
MsgBox "The value is numeric"
Else
MsgBox "The value is not numeric"
End If