Function Fix Ups Class

FixUpVariantToCurrencyMaybeFn

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

Signature (Visual Basic / VBA)

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

Parameters

Parameter Description
rArgument Argument that is checked for compatibility with the Currency data type. Argument will actually be converted to a Currency 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.