Function Fix Ups Class

FixUpVariantToDecimalMaybeFn

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

Signature (Visual Basic / VBA)

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

Parameters

Parameter Description
rArgument Argument that is checked for compatibility with the Decimal data type. Argument will actually be converted to a Decimal 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.
v1.5 Addition This function is new to version 1.5 of Entisoft Tools.