Function Comparisons Class

CanBeBoolean

Determine if the argument can be converted to a Boolean value.

Signature (Visual Basic / VBA)

Public Function CanBeBoolean( _
    ByVal vValue As Variant _
    ) As Boolean

Code Example

    CanBeBoolean(34) = True
    CanBeBoolean(#12:34:56#) = True
    CanBeBoolean("1") = True
    CanBeBoolean("1 word.") = False
    CanBeBoolean("A word.") = False
    CanBeBoolean(Nothing) = False
    CanBeBoolean(Null) = False

Parameters

Parameter Description
vValue The argument which is checked to see if it can be converted to a Boolean value. Function returns True if vValue contains a numeric value, a date, or a numeric string value. Function returns False if vValue is Null, an error, or an object pointer.