Variable             Type Declaration                   Size

Byte                      Dim BVar As Byte                                   0 to 255

Boolean                Dim BoolVar As Boolean               True or False

String        $        Dim Str_Var As String                0 to 65,500 char          

Integer       %           Dim Int_Var As Integer                            2 bytes                          

Long         &        Dim Long_Var As Long                           4 bytes

Single        !         Dim Sing_Var As Single                           4 bytes                       

Double      #        Dim Dbl_Var As Double                           8 bytes

Variant                  Dim X As Any      

Currency               Dim Cvar As Currency                              8 bytes

Object                   Dim X As Object                                       4 bytes

Date                      Dim D As Date                                          8  bytes

User Defined Types                                                 size of each element