Export (0) Print
Expand All
Expand Minimize

TypeName Function

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

TypeName(varname)

The required varname argument can be any variable.

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

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

Community Additions

ADD
Show:
© 2014 Microsoft