Signature (Visual Basic / VBA)
Public Sub FixUpVariantToBooleanMandSub( _
ByRef rArgument As Variant _
, ByVal vDefault As Variant _
)
Code Examples
Assuming
Dim varFlag As Variant
varFlag = "0"
for example
FixUpVariantToBooleanMandSub varFlag, True
leaves
varFlag = False
VarType(varFlag) = vbBoolean
Assuming
Dim varFlag2 As Variant
varFlag2 = "Word"
for example
FixUpVariantToBooleanMandSub varFlag2, True
leaves
varFlag2 = True
Assuming
Dim varFlag3 As Variant
varFlag3 = "Word"
for example
FixUpVariantToBooleanMandSub varFlag3, Null
leaves
IsNull(varFlag3) = True
Parameters
| Parameter | Description |
|---|---|
| rArgument | The argument which is changed to a Boolean value, if possible. Subroutine assigns the default vDefault to rArgument if conversion was 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 will likely be modified. |
| Note | The default value can be a data type other than Boolean (as in example #3) as long as it is compatible with the variable passed via rArgument. |