Visual Basic for Applications Reference

  • Article

IsNumeric Function Example

This example uses the IsNumeric function to determine if a variable can be evaluated as a number.

  Dim MyVar, MyCheck
MyVar = "53"   ' Assign value.
MyCheck = IsNumeric(MyVar)   ' Returns True.

MyVar = "459.95"   ' Assign value.
MyCheck = IsNumeric(MyVar)   ' Returns True.

MyVar = "45 Help"   ' Assign value.
MyCheck = IsNumeric(MyVar)   ' Returns False.