TypeName

Syntax

TypeName[$](var)

Description

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

Parameter	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.
Integer	Variable contains an integer value.
Long	Variable contains a long 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.
Boolean	Variable contains a boolean value.
Variant	Variable contains a variant value. (Only used for arrays of variants.)
Unknown	Variable contains a non-ActiveX Automation object reference.
Byte	Variable contains a byte value.
	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