Function Fix Ups Class

FixUpVariantToDoubleMaybeFn

"Fix Up Variant To Double Maybe Function" Return True if rArgument can be converted to a Double value. Return False otherwise. Numeric strings are converted into Double values, date/time strings are converted into Date values, and other values are left as-is.

Signature (Visual Basic / VBA)

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

Parameters

Parameter Description
rArgument Argument that is checked for compatibility with the Double data type. Argument will actually be converted to a Double value if it is a numeric string or date/time string. Function returns True if conversion is possible or was completed. Function returns False if conversion is 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 may be modified.