VBA/Excel/Access/Word/Data Type/Data Type

Common Data Types

   <source lang="vb">

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

</source>
   
  

Constants are declared using the Const keyword

   <source lang="vb">

Sub Constants()

   Const PI = 3.14159
   Dim circumference As Single
   Dim diameter As Single
   diameter = 10.32
   circumference = PI * diameter

End Sub

</source>
   
  

variable answer will hold the value 32 after execution of this block, not 31.8 as you might want.

   <source lang="vb">

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

</source>