TypeName Function

Syntax:
TypeName[$](var)
Group: Variable Info
Description:
Return a string indicating the type of value stored in var.
Parameter Description
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-OLE 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