## With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

No credit card required

VarType Function

## Syntax

`VarType(`varname`)`
`varname`

Use: Required

The name of a variable.

## Return Value

A Variant of subtype Integer representing the data subtype of `varname`.

## Description

Determines the data subtype of a specified variable.

## Rules at a Glance

• The following intrinsic constants can test the return value of the `VarType` function:

Constant

Value

Datatype

`vbBoolean`

11

Boolean

`vbByte`

17

Byte

`vbCurrency`

6

Currency

`vbDataObject`

13

A data access object variable

`vbDate`

7

Date

`vbDecimal`

14

Decimal

`vbDouble`

5

Double-precision floating-point number

`vbEmpty`

0

Uninitialized

`vbError`

10

An error

`vbInteger`

2

Integer

`vbLong`

3

Long integer

`vbNull`

1

No valid data

`vbObject`

9

Variable explicitly declared as type Object

`vbSingle`

4

Single-precision floating-point number

`vbString`

8

String

`cbUserDefinedType`

36

User-defined type

`vbVariant`

12

Variantâ€”returned only with `vbArray` (8194)

• If `varname` is an array, the `VarType` function returns 8200 (`vbArray`) and `vbVariant`.

• To test for an array, you can use the intrinsic constant `vbArray`. For example:

```If VarType(myVar) And vbArray Then
MsgBox "This is an array"
End If```

Alternatively, you can also use the `IsArray` function.

## Programming Tips & Gotchas

• When you use `VarType` with an object variable, you may get what appears to be an incorrect return value. The reason for this is that if the object has a default property, `VarType` returns the datatype of the default property.

• The `VarType ...`

## With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

No credit card required