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