Function Convert Values Class

VariantToVBConstExpression

"Variant To Visual Basic Constant Expression" Return the string representation of any type of value as it would appear within Visual Basic code.

Signature (Visual Basic / VBA)

Public Function VariantToVBConstExpression( _
    ByVal vValue As Variant _
    ) As String

Code Example

    VariantToVBConstExpression(False) = "False"
    VariantToVBConstExpression(CInt(2)) = "2%"
    VariantToVBConstExpression(CSng(2)) = "2!"
    VariantToVBConstExpression(CByte(2)) = "2%" ' #4
    VariantToVBConstExpression(#4/5/96#) = "#4/5/96#"
    VariantToVBConstExpression("Word") = """Word"""
    VariantToVBConstExpression(Null) = "Null"

Parameters

Parameter Description
vValue The value whose Visual Basic source code representation will be returned. Function generates an error when passed things like object pointers which have no string representation.

Notes & Version History

Note Bytes represented with the Integer type character as in example #4.