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

Материал из VB Эксперт
Версия от 12:48, 26 мая 2010; Admin (обсуждение | вклад) (1 версия)
(разн.) ← Предыдущая | Текущая версия (разн.) | Следующая → (разн.)
Перейти к: навигация, поиск

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