Syntax:
TypeName[$](var)
Group: Variable Info
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