VB & VBA in a Nutshell: The Language

TypeName Function

Named Arguments

No

Syntax

TypeName(varname)

varname

Use: Required

Data Type: Any

The name of a variable.

Return Value

A String

Description

Returns a string containing the name of the data type of a variable.

Rules at a Glance

• If varname is a Variant, TypeName returns the variant's data subtype. If the variant has not been assigned a value, TypeName returns Empty. Therefore, TypeName never actually returns the string "Variant."

• TypeName can't be used with a user-defined type.

• The following table describes the possible return values and their meaning:

  Return Value	Underlying Data Type
  Boolean	Boolean
  Byte	Byte
  classname	An object variable explicitly declared as type classname
  Currency	Currency
  Date	Date
  Decimal	Decimal
  Double	Double-precision floating-point number
  Empty	Uninitialized variant
  Error	An error
  Integer	Integer
  Long	Long integer
  Nothing	Unassigned object variable
  Null	No valid data
  Object	Variable explicitly declared as type Object
  Single	Single-precision floating-point number
  String	String
  Unknown	An object whose type is unknown
  Variant()	A variant containing an array created using the Array function

• If varname contains an array, TypeName appends the appropriate data type name with empty parentheses to denote an array. For example, an array of String returns String().

See Also

VarType Function