Function Convert Values Class

CDecIgnErr

"Convert To Decimal Ignore Errors" Attempt to convert vValue to a Decimal value. Return vValue as a Decimal value if the conversion was successful. Return Empty if vValue could not be converted to a Decimal.

Signature (Visual Basic / VBA)

Public Function CDecIgnErr( _
    ByVal vValue As Variant _
    ) As Variant

Code Example

    CDecIgnErr(34.5) = 34.5
    CDecIgnErr(0) = 0
    CDecIgnErr(-34.5) = -34.5
    IsEmpty(CDecIgnErr(1E300)) = True
    CDecIgnErr("1") = 1
    CDecIgnErr("0") = 0
    IsEmpty(CDecIgnErr("Word")) = True

Parameters

Parameter Description
vValue The value which will be converted to Decimal and returned (if conversion is possible). Conversion is not possible if vValue is Null, an Error, an Object, a non-numeric String, or a numeric value out of the range allowed for this data type.

Notes & Version History

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