VarType Constants
This page is specific to the Visual Basic for Applications (VBA) Language Reference for Office 2010.
The following constants can be used anywhere in your code in place of the actual values:
Constant |
Value |
Description |
|---|---|---|
vbEmpty |
0 |
Uninitialized (default) |
vbNull |
1 |
Contains no valid data |
vbInteger |
2 |
|
vbLong |
3 |
Long integer |
vbSingle |
4 |
Single-precision floating-point number |
vbDouble |
5 |
Double-precision floating-point number |
vbCurrency |
6 |
|
vbDate |
7 |
|
vbString |
8 |
|
vbObject |
9 |
Object |
vbError |
10 |
Error |
vbBoolean |
11 |
|
vbVariant |
12 |
|
vbDataObject |
13 |
Data access object |
vbDecimal |
14 |
|
vbByte |
17 |
|
vbLongLong |
20 |
LongLong integer (Valid on 64-bit platforms only.) |
vbUserDefinedType |
36 |
Variants that contain user-defined types |
vbArray |
8192 |
Array |