Data Types
Data Type | Default | Range | Size | Abr. | Comments |
Byte | 0 to 255 | 1 byte (8 bits) | (by) integers often used in conjunction with string operations Use Long instead | ||
Currency | 0 | - 9.2 E+14 to + 9.2 E+14 | 8 bytes (64 bits) | @ | (c) scaled integer Use Double instead |
Decimal* | - 7.9 E+28 to + 7.9 E+28 | 14 bytes | (dec) Variant subtype Must be declared as a Variant and then converted using the CDec function | ||
Double | 0 | - 1.8 E+308 to + 4.9 E+324 | 8 bytes (64 bits) | # | (db) double precision floating point used for high accuracy |
Integer | 0 | - 32,768 to + 32,767 | 2 bytes (16 bits) | % | (i) Use Long instead |
Long | 0 | - 2.1 E+9 to + 2.1 E+9 | 4 bytes (32 bits) | & | (l) long integer |
LongLong | Added in Office 2010, VBA 7.0 | ||||
LongPtr | Added in Office 2010, VBA 7.0 Long on 32 bit LongLong on 64 bit | ||||
Single | 0 | - 1.3 E+38 to + 1.3 E+38 | 4 bytes (32 bits) | ! | (sng) single precision floating point used when you have fractional numbers Use Double instead |
© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited TopPrevNext