TypeName Function
Returns a string that provides Variant subtype information about a variable.
TypeName(varname)
Arguments
The required varname argument can be any variable.
Return Value
The TypeName function has the following return values:
Value |
Description |
---|---|
Byte |
Byte value |
Integer |
Integer value |
Long |
Long integer value |
Single |
Single-precision floating-point value |
Double |
Double-precision floating-point value |
Currency |
Currency value |
Decimal |
Decimal value |
Date |
Date or time value |
String |
Character string value |
Boolean |
Boolean value; True or False |
Empty |
Uninitialized |
Null |
No valid data |
<object type> |
Actual type name of an object |
Object |
Generic object |
Unknown |
Unknown object type |
Nothing |
Object variable that doesn't yet refer to an object instance |
Error |
Error |
Remarks
The following example uses the TypeName function to return information about a variable:
Dim ArrayVar(4), MyType
NullVar = Null ' Assign Null value.
MyType = TypeName("VBScript") ' Returns "String".
MyType = TypeName(4) ' Returns "Integer".
MyType = TypeName(37.50) ' Returns "Double".
MyType = TypeName(NullVar) ' Returns "Null".
MyType = TypeName(ArrayVar) ' Returns "Variant()".