Table of contents
TOC
Collapse the table of content
Expand the table of content

VarType Constants

office 365 dev account|Last Updated: 6/12/2017
|
1 Contributor

The following constants can be used anywhere in your code in place of the actual values:

ConstantValueDescription
vbEmpty0Uninitialized (default)
vbNull1Contains no valid data
vbInteger2Integer
vbLong3Long integer
vbSingle4Single-precision floating-point number
vbDouble5Double-precision floating-point number
vbCurrency6Currency
vbDate7Date
vbString8String
vbObject9Object
vbError10Error
vbBoolean11Boolean
vbVariant12Variant (used only forarrays of variants)
vbDataObject13Data access object
vbDecimal14Decimal
vbByte17Byte
vbLongLong20LongLong integer (Valid on 64-bit platforms only.)
vbUserDefinedType36Variants that contain user-defined types
vbArray8192Array
© 2017 Microsoft