VBA/Excel/Access/Word/Data Type/Data Type
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
Constants are declared using the Const keyword
Sub Constants()
Const PI = 3.14159
Dim circumference As Single
Dim diameter As Single
diameter = 10.32
circumference = PI * diameter
End Sub
variable answer will hold the value 32 after execution of this block, not 31.8 as you might want.
Sub IntegerType()
Dim answer As Integer
Dim num1 As Single
Dim num2 As Integer
num1 = 5.3
num2 = 6
answer = num1 * num2
Debug.Print answer
End Sub