Function Convert Values Class

CSngIgnErr

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

Signature (Visual Basic / VBA)

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

Code Example

    CSngIgnErr(34) = 34!
    CSngIgnErr(0) = 0!
    CSngIgnErr(-34) = -34!
    CSngIgnErr(34.3) = 34.3!
    CSngIgnErr("1") = 1!
    CSngIgnErr("0") = 0!
    CSngIgnErr(#12/31/1899#) = 1!
    CSngIgnErr("Word") = 0!

Parameters

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