Function Convert Values Class

CLngIgnErr

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

Signature (Visual Basic / VBA)

Public Function CLngIgnErr( _
    ByVal vValue As Variant _
    ) As Long

Code Example

    CLngIgnErr(34) = 34&
    CLngIgnErr(0) = 0&
    CLngIgnErr(-34) = -34&
    CLngIgnErr(34.3) = 34&
    CLngIgnErr(123456) = 123456&
    CLngIgnErr(1E40) = 0&
    CLngIgnErr("1") = 1&
    CLngIgnErr("0") = 0&
    CLngIgnErr(#12/31/1899#) = 1&
    CLngIgnErr("Word") = 0&

Parameters

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