Function Illustrate Values Class

IllustrateValue

Illustrate a Variant value and its data type. Non-printable characters within String values are converted to their keyboard equivalent.

Signature (Visual Basic / VBA)

Public Function IllustrateValue( _
    ByVal vValue As Variant _
    ) As Variant

Code Example

    ? IllustrateValue("Line1" + vbCrLf + "Line2")
    "Line1%013%010Line2" (String * 12)
    ? IllustrateValue(23%)
    23 (Integer)
    ? IllustrateValue(23&)
    23 (Long)
    ? IllustrateValue(EmptyValue)
    (Empty)
    ? IllustrateValue(Null)
    Null (Null)

Parameters

Parameter Description
vValue The value that will be illustrated (converted to a string) along with its data type.

Notes & Version History

Note This function uses IllustrateKeys to illustrate String values, and it uses VarTypeToString to get the value's data type.