Data Types
A Data Type refers to how the data is stored in memory and how many bytes that data needs.
You should always try and use the data type that uses the smallest number of bytes
Data Type | CType | Default | Range | Size | Abr. | (Prefix) Comments |
Byte | CByte | 0 to 255 | 1 byte (8 bits) | (by) integers often used in conjunction with string operations Use Long instead | ||
Currency | CCur | 0 | - 9.2 E+14 to + 9.2 E+14 | 8 bytes (64 bits) | @ | (c) scaled integer Use Double instead |
Decimal* | CDec | - 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 | CDbl | 0 | - 1.8 E+308 to + 4.9 E+324 | 8 bytes (64 bits) | # | (db) double precision floating point used for high accuracy |
Integer | CInt | 0 | - 32,768 to + 32,767 | 2 bytes (16 bits) | % | (i) integer Use Long instead |
Long | CLng | 0 | - 2.1 E+9 to + 2.1 E+9 | 4 bytes (32 bits) | & | (l) long integer |
LongLong | CLngLng | (ll) Added in Office 2010, VBA 7.0 | ||||
LongPtr | CLngPtr | (lp) Added in Office 2010, VBA 7.0 Long on 32 bit LongLong on 64 bit | ||||
Single | CSng | 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 |
© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited TopPrevNext