VarType Function

Syntax:

VarType(var)

Group: Variable Info

Description:
Return a number indicating the type of value stored in var.

Parameter Description

 

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