Syntax:
VarType(var)
Group: Variable Info
Description:
Return a number indicating the type of value stored in var.
Parameter Description
var Return a number indicating the type of value stored in this variable.
Result |
Value |
Description |
vbEmpty |
0 |
Variant variable is empty. It has never been assigned a value. |
vbNull |
1 |
Variant variable is null. |
vbInteger |
2 |
Variable contains an integer value. |
vbLong |
3 |
Variable contains a long value. |
vbSingle |
4 |
Variable contains a single value. |
vbDouble |
5 |
Variable contains a double value. |
vbCurrency |
6 |
Variable contains a currency value. |
vbDate |
7 |
Variable contains a date value. |
vbString |
8 |
Variable contains a string value. |
vbObject |
9 |
Variable contains an object reference. |
vbError |
10 |
Variable contains a error code value. |
vbBoolean |
11 |
Variable contains a boolean value. |
vbVariant |
12 |
Variable contains a variant value. (Only used for arrays of variants.) |
vbDataObject |
13 |
Variable contains a non-ActiveX Automation object reference. |
vbDecimal |
14 |
Variable contains a 96 bit scaled real. |
vbByte |
17 |
Variable contains a byte value. |
vbUserDefinedType |
36 |
Variable contains a User Defined Type value. |
vbArray |
8192 |
Variable contains an array value. Use VarType( ) And 255 to get the type of element stored in the array. |
See Also: TypeName.
Example:
Sub Main
Dim X As Variant
Debug.Print
VarType(X) ' 0
X = 1
Debug.Print
VarType(X) ' 2
X = 100000
Debug.Print
VarType(X) ' 3
X = 1.1
Debug.Print
VarType(X) ' 5
X = "A"
Debug.Print
VarType(X) ' 8
Set X = CreateObject("Word.Basic")
Debug.Print
VarType(X) ' 9
X = Array(0,1,2)
Debug.Print
VarType(X) ' 8204 (8192+12)
End Sub