Function Convert Values Class

VariantIsBlank

Return True if argument is Empty, Null, or a blank String. Function returns False otherwise.

Signature (Visual Basic / VBA)

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

Code Example

    VariantIsBlank(Null) = True
    VariantIsBlank(EmptyValue) = True
    VariantIsBlank("") = True
    VariantIsBlank("Word") = False
    VariantIsBlank(0) = False
    VariantIsBlank(123) = False

Parameters

Parameter Description
vValue The value that will be examined to see if it is Empty, Null, or a blank String.