VarType

VarType(variable)

Description

VarType returns an integer that indicates the type of a variable. The required parameter, variable, is any variable that doesn't contain a user-defined type.

When variable is an array, the value returned is equal to the array constant plus the constant that specifies the element-type.

Table 25: VarType return values

Constant	Value	Description
vbEmpty	0	Empty
vbNull	1	Null
vbInteger	2	Integer
vbLong	3	Long
vbSingle	4	Single-precision floating-point
vbDouble	5	Double-precision floating-point
vbCurrency	6	Currency
vbDate	7	Date
vbString	8	String
vbObject	9	Object
vbError	10	Error
vbBoolean	11	Boolean
vbVariant	12	Variant
vbDataObject	13	Data-access Object
vbByte	17	Byte
vbArray	8192	Array

Example

Rem VarType Example
'VarType returns variable type as an integer
Dim nInteger, nSingle
nInteger = CInt(44)
Print 44 & " is VarType " & VarType(nInteger)
nSingle = CSNG(99.44)
Print 99.44 & "isVarType" & VarType(nSingle)

Output

44 is VarType 2
99.44 is VarType 4

Related Items

Is, TypeName