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.
The default value for all the number data types is zero.

Byte (0 to 255)(by) very small integers, use Long instead
1 byte (8 bits)
Conversion - CByte
Integer (- 32,768 to + 32,767)(i) small integers, use Long instead
2 bytes (16 bits)
Conversion - CInt, Abbreviation Suffix - %
Long (- 2.1 E+9 to + 2.1 E+9)(l) very large integers
4 bytes (32 bits)
Conversion - CLng, Abbreviation Suffix - &
Single (- 1.3 E+38 to + 1.3 E+38)(sg) single precision floating point for decimals, use Double instead
4 bytes (32 bits)
Conversion - CSng, Abbreviation Suffix - !
Double (- 1.8 E+308 to + 4.9 E+324)(db) double precision floating point for decimals
8 bytes (64 bits)
Conversion - CDbl, Abbreviation Suffix - #
Currency (- 9.2 E+14 to + 9.2 E+14)(c) scaled integer, use Double instead
8 bytes (64 bits)
Conversion - CCur, Abbreviation Suffix - @
Decimal* (- 7.9 E+28 to + 7.9 E+28)(dv) Variant subtype
Must be declared as a Variant and then converted using the CDec function
14 bytes (112 bits)
Conversion - CDec
LongLong(ll) Added in Office 2010, VBA 7.0
Conversion - CLngLng, Abbreviation Suffix - ^
LongPtr(lp) Added in Office 2010, VBA 7.0
LongLong on 64 bit, Long on 32 bit
Conversion - CLngPtr
Byte (0 to 255)
(by) very small integers, use Long instead
1 byte (8 bits)
Conversion - CByte
Integer (- 32,768 to + 32,767)
(i) small integers, use Long instead
2 bytes (16 bits)
Conversion - CInt, Abbreviation Suffix - %
Long (- 2.1 E+9 to + 2.1 E+9)
(l) very large integers
4 bytes (32 bits)
Conversion - CLng, Abbreviation Suffix - &
Single (- 1.3 E+38 to + 1.3 E+38)
(sg) single precision floating point for decimals, use Double instead
4 bytes (32 bits)
Conversion - CSng, Abbreviation Suffix - !
Double (- 1.8 E+308 to + 4.9 E+324)
(db) double precision floating point for decimals
8 bytes (64 bits)
Conversion - CDbl, Abbreviation Suffix - #
Currency (- 9.2 E+14 to + 9.2 E+14)
(c) scaled integer, use Double instead
8 bytes (64 bits)
Conversion - CCur, Abbreviation Suffix - @
Decimal* (- 7.9 E+28 to + 7.9 E+28)
(dv) Variant subtype
Must be declared as a Variant and then converted using the CDec function
14 bytes (112 bits)
Conversion - CDec
LongLong
(ll) Added in Office 2010, VBA 7.0
Conversion - CLngLng, Abbreviation Suffix - ^
LongPtr
(lp) Added in Office 2010, VBA 7.0
LongLong on 64 bit, Long on 32 bit
Conversion - CLngPtr

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