All Constants
Color Constants
Comparison Constants
Date Format Constants
Date and Time Constants
Drive Object
FileAttribute Property
File Input/Output Constants
MsgBox Constants
String Constants
Tristate Constants
CONSTANTS: VarType
VarType Constants
You may use either the CONSTANT (left column) or the VALUE (center column) in your code and get the same results.
CONSTANT
VALUE
DESCRIPTION
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-2004 by Infinite Software Solutions, Inc. All rights reserved.
Trademark Information