Function Comparisons Class

CanBeDecimal

Determine if the argument can be converted to a Decimal value.

Signature (Visual Basic / VBA)

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

Code Example

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

Parameters

Parameter Description
vValue The argument which is checked to see if it can be converted to a Decimal value. Function returns True if vValue contains a numeric value, a date, or a numeric string value which is within the range of values supported by the Decimal data type. Function returns False otherwise, such as if vValue is out-of-range, Null, an error, or an object pointer.

Notes & Version History

v1.5 Addition This function is new to version 1.5 of Entisoft Tools.