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

Home
VBA / Excel / Access / Word
1.Access
2.Application
3.Data Type
4.Data Type Functions
5.Date Functions
6.Excel
7.File Path
8.Forms
9.Language Basics
10.Math Functions
11.Outlook
12.PowerPoint
13.String Functions
14.Windows API
15.Word
16.XML
VBA / Excel / Access / Word » Data Type » Data Type 
Common Data Types
 
Data type     Storage size     Range 
Boolean             bytes    True or False 
Integer             bytes    -32,768 to 32,767 
Long                bytes    -2,147,483,648 to 2,147,483,647 
Single              bytes    -3.402823E38 to -1.401298E-45 for negative values; 1.401298E-45 to 3.402823E38 for positive values 
Double              bytes    -1.79769313486231E308 to -4.94065645841247E-324 for negative values; 4.94065645841247E-324 to 1.79769313486232E308 for positive values 
Date                bytes    January 1100 to December 319999 
Object              bytes    Any Object reference 
String              10 bytes   to approximately billion 
Variant numbers     16 bytes   Any numeric value up to the range of a Double 
Variant characters22 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
www.java2java.com | Contact Us
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.