TypeName Function; VarType Function /text/sbasic/shared/03103600.xhp
TypeName function VarType function Basic Variable Type constants

TypeName Function; VarType Function

Returns a string (TypeName) or a numeric value (VarType) that contains information for a variable.
TypeName (Variable) / VarType (Variable) String; Integer Variable: The variable that you want to determine the type of. You can use the following values:
Keyword Named constant VarType Variable type Boolean 11 Boolean variable Byte 17 Byte 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
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 $[officename] Basic" End Sub