Function Comparisons Class

IsNumber

Return True if the data type of the argument is numeric. Function returns False otherwise. More specifically, it considers the following data types numeric: Boolean, Byte, Currency, Date, Double, Integer, Long, and Single.

Signature (Visual Basic / VBA)

Public Function IsNumber( _
    ByVal vValue As Variant _
    ) As Boolean

Code Example

    IsNumber(34) = True
    IsNumber(1234.56) = True
    IsNumber(#12/31/95#) = True
    IsNumber("34") = False
    IsNumber("A word.") = False

Parameters

Parameter Description
vValue Value whose data type is examined to see if it is numeric.

Notes & Version History

v1.5 Change This function has been extended to support the new Decimal data type in VB 6.0.