Variable Type Constants

The VarType constant returns one of the following constants to indicate the data subtype of the variable passed to it as a parameter. The exception is an array, which returns a value of 8204, or vbArray Or vbVariant.

Constant

Value

Description

vbArray

8192

Array

vbBoolean

11

Boolean

vbByte

17

Byte

vbCurrency

6

Currency

vbDataObject

13

Data Object

vbDate

7

Date

vbDecimal

14

Decimal (unavailable in VBScript)

vbDouble

5

Double

vbEmpty

0

Empty

vbError

10

Error

vbInteger

2

Integer

vbLong

3

Long

vbNull

1

Null

vbObject

9

Object

vbSingle

4

Single

vbString

8

String

vbVariant

12

Variant

Get VBScript in a Nutshell now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.