Function Fix Ups Class

FixUpVariantToLongMaybeFn

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

Signature (Visual Basic / VBA)

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

Parameters

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