VbVarType

Variant subtype codes returned by the VarType function. Most calls return a single value from the table below. Arrays are reported as vbArray added to the element subtype — for example, an array of Long returns vbArray + vbLong = 8195.

Constant Value Description
vbEmpty 0 Empty (uninitialized).
vbNull 1 Null (no valid data).
vbInteger 2 Integer.
vbLong 3 Long integer.
vbSingle 4 Single-precision floating-point number.
vbDouble 5 Double-precision floating-point number.
vbCurrency 6 Currency value.
vbDate 7 Date value.
vbString 8 String.
vbObject 9 Object reference.
vbError 10 Error value.
vbBoolean 11 Boolean value.
vbVariant 12 Variant (used only with arrays of variants).
vbDataObject 13 A data access object.
vbDecimal 14 Decimal value.
vbByte 17 Byte value.
vbLongLong 20 LongLong integer (64-bit only).
vbUserDefinedType 36 Variant containing a user-defined type.
vbArray 8192 Array. Always added to another value when returned.

Note

The Decimal subtype (vbDecimal) is reserved but not currently supported in twinBASIC. The constant is defined for source compatibility with VBA.

License: CC-BY-4.0 Code license: MIT Attribution: VBA-Docs