TypeName Function

Returns a string that provides Variant subtype information about a variable.

Syntax

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()".

Requirements

Version 2

See Also

IsArray Function
IsDate Function
IsEmpty Function
IsNull Function
IsNumeric Function
IsObject Function
VarType Function