Function Fix Ups Class

FixUpVariantToBooleanMandFn

"Fix Up Variant To Boolean Mandatory Function" Convert numeric, date/time, numeric string, and date/time string Variant values to the Boolean data type. Return True if the conversion was completed successfully. Return False otherwise.

Signature (Visual Basic / VBA)

Public Function FixUpVariantToBooleanMandFn( _
    ByRef rArgument As Variant _
    ) As Boolean

Code Examples

    Assuming
       Dim varFlag As Variant
       varFlag = "0"
    for example
       FixUpVariantToBooleanMandFn(varFlag) = True
    leaves
       varFlag = False
       VarType(varFlag) = vbBoolean
    Assuming
       Dim varFlag2 As Variant
       varFlag2 = "Word"
    for example
       FixUpVariantToBooleanMandFn(varFlag2) = False
    leaves
       varFlag2 = "Word"

Parameters

Parameter Description
rArgument The argument which is changed to a Boolean value, if possible. Function returns False if conversion was not possible, such as when the argument is out-of-range, missing, Null, an error, a pointer, or a non-numeric string.

Notes & Version History

Note rArgument is a passed by reference, so the variable passed from the calling function will likely be modified.