TypeName Function; VarType Function
Returns a string (TypeName) or a numeric value (VarType) that contains information for a variable.
Syntax:
TypeName (Variable) / VarType (Variable)
Return value:
String; Integer
Parameters:
Variable: The variable that you want to determine the type of. You can use the following values:
|
key word |
Named constant |
VarType |
Variable type |
|
Boolean |
|
11 |
Boolean variable |
|
Date |
V_DATE |
7 |
Date variable |
|
Currency |
V_CURRENCY |
6 |
Currency variable |
|
Double |
V_DOUBLE |
5 |
Double floating point variable |
|
Integer |
V_INTEGER |
2 |
Integer variable |
|
Long |
V_LONG |
3 |
Long integer variable |
|
Object |
|
9 |
Object variable |
|
Single |
V_SINGLE |
4 |
Single floating-point variable |
|
String |
V_STRING |
8 |
String variable |
|
Variant |
|
12 |
Variant variable (can contain all types specified by the definition) |
|
Empty |
V_EMPTY |
0 |
Variable is not initialized |
|
Null |
V_NULL |
1 |
No valid data |
Example:
Sub ExampleType
Dim iVar As Integer
Dim sVar As String
Dim siVar As Single
Dim dVar As Double
Dim bVar As Boolean
Dim lVar As Long
Dim cVar as Currency
Dim tVar as Date
MsgBox TypeName(iVar) & " " & VarType(iVar) & Chr(13) &_
TypeName(sVar) & " " & VarType(sVar) & Chr(13) &_
TypeName(siVar) & " " & VarType(siVar) & Chr(13) &_
TypeName(dVar) & " " & VarType(dVar) & Chr(13) &_
TypeName(bVar) & " " & VarType(bVar) & Chr(13) &_
TypeName(cVar) & " " & VarType(cVar) & Chr(13) &_
TypeName(tVar) & " " & VarType(tVar) & Chr(13) &_
TypeName(lVar) & " " & VarType(lVar),0,"Some types In Collabora Office Basic"
End Sub