Common Data Types : Data Type « Data Type « VBA / Excel / Access / Word






Common Data Types

 
Data type     Storage size     Range 
Boolean             2 bytes    True or False 
Integer             2 bytes    -32,768 to 32,767 
Long                4 bytes    -2,147,483,648 to 2,147,483,647 
Single              4 bytes    -3.402823E38 to -1.401298E-45 for negative values; 1.401298E-45 to 3.402823E38 for positive values 
Double              8 bytes    -1.79769313486231E308 to -4.94065645841247E-324 for negative values; 4.94065645841247E-324 to 1.79769313486232E308 for positive values 
Date                8 bytes    January 1, 100 to December 31, 9999 
Object              4 bytes    Any Object reference 
String              10 bytes   0 to approximately 2 billion 
Variant numbers     16 bytes   Any numeric value up to the range of a Double 
Variant characters) 22 bytes   Same range as for variable-length String 
 








Related examples in the same category

1.variable answer will hold the value 32 after execution of this block, not 31.8 as you might want.
2.Constants are declared using the Const keyword