VBA's Built-in Data Types

VBA's Built-in Data Types

 

Data Type	Storage Required	Range of Values
Boolean (Logical)	2 bytes	True or False
Integer	2 bytes	-32,768 to 32,767
Long integer	4 bytes	-2,147,483,648 to 2,147,483,647
Single precision	4 bytes	-3.402823E+38 to -1.401298E-45 for negative values; 1.401298E-45 to 3.402823E+38 for positive values
Double precision	8 bytes	-1.797693 13486232E+308 to -4.9406564584 1247E-324  for negative values; 4.94065645841247E-324 to 1.797693 13486232E+308  for positive values -922,337,203,685,477.5808 to 922,337,203,685,477.5807
Currency	8 bytes
Date	8 bytes	Any Object reference
Object	4 bytes
String	1 byte character
Variant	16 bytes + 1 byte/character	Any numeric value up to the range of a Double or anv text