Signature (Visual Basic / VBA)
Public Sub FixUpVariantToBooleanMaybeSub( _
ByRef rArgument As Variant _
, ByVal vDefault As Variant _
)
Code Examples
Assuming
Dim varFlag As Variant
varFlag = "0"
for example
FixUpVariantToBooleanMaybeSub varFlag, True
leaves
varFlag = False
VarType(varFlag) = vbBoolean
Assuming
Dim varFlag2 As Variant
varFlag2 = 0
for example
FixUpVariantToBooleanMaybeSub varFlag2, True
leaves
varFlag2 = 0
VarType(varFlag2) = vbInteger
Assuming
Dim varFlag3 As Variant
varFlag3 = "Word"
for example
FixUpVariantToBooleanMandSub varFlag3, True
leaves
varFlag3 = True
varType(varFlag3) = vbBoolean
Parameters
| Parameter | Description |
|---|---|
| rArgument | Argument that is checked for compatibility with the Boolean data type. Argument will actually be converted to a Boolean value if it is a numeric string or date/time string. Subroutine assigns the default value vDefault to rArgument if conversion is not possible, such as when the rArgument is out-of-range, missing, Null, an error, a pointer, or a non-numeric string. |
| vDefault | The default value which is assigned to rArgument when conversion is not possible. |
Notes & Version History
| Note | rArgument is a passed by reference, so the variable passed from the calling function may be modified. |
| Note | The default value can be a data type other than Boolean as long as it is compatible with the variable passed via rArgument. |