Export (0) Print
Expand All

VarType Function

Returns a value indicating the subtype of a variable.

VarType(varname)

The varname argument can be any variable.

The VarType function returns the following values:

Constant

Value

Description

vbEmpty

0

Empty (uninitialized)

vbNull

1

Null (no valid data)

vbInteger

2

Integer

vbLong

3

Long integer

vbSingle

4

Single-precision floating-point number

vbDouble

5

Double-precision floating-point number

vbCurrency

6

Currency

vbDate

7

Date

vbString

8

String

vbObject

9

Automation object

vbError

10

Error

vbBoolean

11

Boolean

vbVariant

12

Variant (used only with arrays of Variants)

vbDataObject

13

A data-access object

vbByte

17

Byte

vbArray

8192

Array

Note Note:

These constants are specified by VBScript. As a result, the names can be used anywhere in your code in place of the actual values.

The VarType function never returns the value for Array by itself. It is always added to some other value to indicate an array of a particular type. The value for Variant is only returned when it has been added to the value for Array to indicate that the argument to the VarType function is an array. For example, the value returned for an array of integers is calculated as 2 + 8192, or 8194. If an object has a default property, VarType (object) returns the type of its default property.

The following example uses the VarType function to determine the subtype of a variable.

Dim MyCheck
MyCheck = VarType(300)          ' Returns 2.
MyCheck = VarType(#10/19/62#)   ' Returns 7.
MyCheck = VarType("VBScript")   ' Returns 8.

Community Additions

Show:
© 2014 Microsoft