Function Convert Values Class

CCurIgnErr

"Convert To Currency Ignore Errors" Attempt to convert vValue to a Currency value. Return vValue as a Currency value if the conversion was successful. Return 0 (zero) if vValue could not be converted to a Currency.

Signature (Visual Basic / VBA)

Public Function CCurIgnErr( _
    ByVal vValue As Variant _
    ) As Currency

Code Example

    CCurIgnErr(34.5) = 34.5@
    CCurIgnErr(0) = 0@
    CCurIgnErr(-34.5) = -34.5@
    CCurIgnErr(1E300) = 0@
    CCurIgnErr("1") = 1@
    CCurIgnErr("0") = 0@
    CCurIgnErr("Word") = 0@

Parameters

Parameter Description
vValue The value which will be converted to Currency 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.