Syntax 

TypeName[$](var)


Group 

Variable Info 


Description 

Return a string indicating the type of value stored in var.


Parameters

Description

var 

Return a string indicating the type of value stored in this variable.


Result

Description

Empty

Variant variable is empty. It has never been assigned a value.

Null

Variant variable is null.

Boolean

Variable contains a Boolean value.

Byte

Variable contains a Byte value.

SByte

Variable contains an SByte value.

Integer

Variable contains an Integer value.

UInteger

Variable contains an UInteger value.

Long

Variable contains a Long value.

ULong

Variable contains a ULong value.

Huge_

Variable contains a Huge_ value.

UHuge_

Variable contains a UHuge_ value.

Decimal

Variable contains a Decimal value.

Single

Variable contains a Single value.

Double

Variable contains a Double value.

Currency

Variable contains a Currency value.

Date

Variable contains a Date value.

String

Variable contains a String value.

Object

Variable contains an Object reference that is not Nothing. (An object may return a type name specific to that type of object.)

Nothing

Variable contains an Object reference that is Nothing.

Error

Variable contains a error code value.

Variant

Variable contains a variant value. (Only used for arrays of variants.)

Unknown

Variable contains a non-ActiveX Automation object reference.

( )

Variable contains an array value. The TypeName of the element followed by ( ).


See Also 

VarType


Example

Sub Main

    Dim X As Variant

    Debug.Print TypeName(X) '"Empty"

    X = 1

    Debug.Print TypeName(X) '"Integer"

    X = 100000

    Debug.Print TypeName(X) '"Long"

    X = 1.1

    Debug.Print TypeName(X) '"Double"

    X = "A"

    Debug.Print TypeName(X) '"String"

    Set X = CreateObject("Word.Basic")

    Debug.Print TypeName(X) '"Object"

    X = Array(0,1,2)

    Debug.Print TypeName(X) '"Variant()"

End Sub