The default value is 0. Single is a signed number data type that represents fractional numbers, decimals, or exponential numbers. The default value is 0. Double is a signed number data type that represents double precision fractional numbers, decimals, or exponential numbers. The default value is 0.
Currency is a fixed point number that is best used for high accuracy calculations.
The default value is 0. Furthermore, string data types can be either fixed or variable in length. Variant is a special data type capable of storing any of the data types in the above table. Unless you explicitly declare your variable as one of the other data types VBA will store it as a variant . The default value is Empty .