Listes des types VBA code example

Example 1: vba type

Public Type MyType
    MyVar1 As Integer
    MaVar2 As Integer
End Type
'-----------------------------------------------------
Dim typo As MyType
typo.MyVar1 = 2

Example 2: vba type variable

debug.print TypeName(my_var)   ' String, Integer, Date...
debug.print VarType(my_var)	   ' vbLong, vbDate...