Programming Reference Manual

VarType

 
Syntax
 
VarType(var)
 
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