VarType Constants
You may use either the CONSTANT (left column) or the VALUE (center column) in your code and get the same results.
VBEmpty 0 Uninitialized
VBNull 1 Contains no valid data
VBInteger 2 Integer subtype
VBLong 3 Long subtype
VBSingle 4 Single subtype
VBDouble 5 Double subtype
VBCurrency 6 Currency subtype
VBDate 7 Date subtype
VBString 8 String subtype
VBObject 9 Object
VBError 10 Error subtype
VBBoolean 11 Boolean subtype
VBVariant 12 Variant (only use for arrays of variants)
VBDataObject 13 Data access object
VBDecimal 14 Decimal subtype
VBByte 17 Byte subtype
VBArray 8192 Array

Copyright 1999-2001 by Infinite Software Solutions, Inc. All rights reserved.
Trademark Information