TypeName Function; VarType Function

Returns a string (TypeName) or a numeric value (VarType) that contains information for a variable.

Sintaksa:


TypeName (Variable) / VarType (Variable)

Vrati vrijednost:

String; Integer

Parametri:

Variable: The variable that you want to determine the type of. You can use the following values:

key word

Named constant

VarType

Tipovi Varijable

Boolean

11

Boolean Varijable

Date

V_DATE

7

Varijable Date (Datum)

Currency

V_CURRENCY

6

Currency variable

Double

V_DOUBLE

5

Double floating point variable

Integer

V_INTEGER

2

Varijable Cijelih Brojeva (Integer)

Long

V_LONG

3

Long Integer Varijable

Object

9

Object variable

Single

V_SINGLE

4

Single floating-point variable

String

V_STRING

8

String Varijable

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


Error codes:

5 Invalid procedure call

Primjer:


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) &_
 ime
End Sub

Please support us!