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 TypeCTypeDefaultRangeSizeAbr.(Prefix) Comments
ByteCByte 0 to 2551 byte
(8 bits)
 (by) integers often used in conjunction with string operations
Use Long instead
CurrencyCCur0- 9.2 E+14 to + 9.2 E+148 bytes
(64 bits)
@(c) scaled integer
Use Double instead
Decimal*CDec - 7.9 E+28 to + 7.9 E+2814 bytes (dec) Variant subtype
Must be declared as a Variant and then converted using the CDec function
DoubleCDbl0- 1.8 E+308 to + 4.9 E+3248 bytes
(64 bits)
#(db) double precision floating point used for high accuracy
IntegerCInt0- 32,768 to + 32,7672 bytes
(16 bits)
%(i) integer
Use Long instead
LongCLng0- 2.1 E+9 to + 2.1 E+94 bytes
(32 bits)
&(l) long integer
LongLongCLngLng    (ll) Added in Office 2010, VBA 7.0
LongPtrCLngPtr    (lp) Added in Office 2010, VBA 7.0
Long on 32 bit
LongLong on 64 bit
SingleCSng0- 1.3 E+38 to + 1.3 E+384 bytes
(32 bits)
!(sng) single precision floating point used when you have fractional numbers
Use Double instead

© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited TopPrevNext