VarType Function |
Main Menu |
Syntax
VarType(varname)
The varname argument can be any variable.
Return Values
The VarType function returns the following values:
Constant | Value | Description |
vbEmpty | 0 | Empty (uninitialized) |
vbNull | 1 | Null (no valid data) |
vbInteger | 2 | Integer |
vbLong | 3 | Long integer |
vbSingle | 4 | Single-precision floating-point number |
vbDouble | 5 | Double-precision floating-point number |
vbCurrency | 6 | Currency |
vbDate | 7 | Date |
vbString | 8 | String |
vbObject | 9 | Automation object |
vbError | 10 | Error |
vbBoolean | 11 | Boolean |
vbVariant | 12 | Variant (used only with arrays of Variants) |
vbDataObject | 13 | A data-access object |
vbByte | 17 | Byte |
vbArray | 8192 | Array |
Note:
These constants are specified by VBScript. As a result, the names can be used
anywhere in your code in place of the actual values.
Remarks:
The VarType function never returns the value for Array by itself. It is always
added to some other value to indicate an array of a particular type. The value
for Variant is only returned when it has been added to the value for Array to
indicate that the argument to the VarType function is an array. For example,
the value returned for an array of integers is calculated as 2 + 8192, or 8194.
If an object has a default property, VarType (object) returns the type of its
default property.
The following example uses the VarType function to determine the subtype of a variable.
Dim MyCheck
MyCheck = VarType(300) ' Returns 2.
MyCheck = VarType(#10/19/62#) ' Returns 7.
MyCheck = VarType("VBScript") ' Returns 8.
related to
IsArray IsDate
IsEmpty IsNull
IsNumeric IsObject
TypeName
|