Variable | Symbol | 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 |