VBA Data Types in Excel VBA
Here are the available VBA data types in Excel VBA. These are divided into two categories. The first one is numeric data type and otherone is non-numeric data type.
Table of Contents:
VBA Numeric and Non-numeric Data Types in Excel
Here are the VBA Numeric and Non-numeric Data Types in Excel.
| Numeric Data Type | Non-Numeric Data Type |
|---|---|
| Byte | String(Fixed Length) |
| Integer | String(Variable Length) |
| Long | Date |
| Single | Boolean |
| Double | Object |
| Currency | Variant(Numbers) |
| Decimal | Variant(Characters) |
VBA Data Types and Size(Range of Values) in Excel
Let us see the complete details of VBA data types, its memory size, range of values, vba constant, and its default value.
| Data Type | Bytes Used in Memory | Range of Values | Default Value | VBA Constant |
|---|---|---|---|---|
| Byte | 1 byte (8 bits) | 0 to 255 | 0 | vbByte |
| Boolean | 2 bytes (16 bits) | True or False | FALSE | vbBoolean |
| Integer | 2 bytes (16 bits) | -32,768 to 32,767 | 0 | vbInteger |
| Long (long integer) | 4 bytes (32 bits) | -2,147,483,648 to 2,147,483,647 | 0 | |
| LongLong (LongLong integer) | 8 bytes (64 bits) | -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 | 0 | vbLong |
| Single | 4 bytes (32 bits) | -3.402823E38 to -1.401298E-45 for negative values; 1.401298E-45 to 3.402823E38 for positive values | 0 | vbSingle |
| Double | 8 bytes (64 bits) | -1.79769313486231E308 to-4.94065645841247E-324 for negative values; 4.94065645841247E-324 to 1.79769313486232E308 for positive values | 0 | vbDouble |
| Currency | 8 bytes (64 bits) | -922,337,203,685,477.5808 to 922,337,203,685,477.5807 | 0 | vbCurrency |
| Decimal | 14 bytes (112 bits) | +/-79,228,162,514,264,337,593,543,950,335 with no decimal point;+/-7.9228162514264337593543950335 with 28 places to the right of the decimal | vbDecimal | |
| Date | 8 bytes (64 bits) | January 1, 100 to December 31, 9999 | 0:00:00 | vbDate |
| Object | 4 bytes (32 bits) | Any Object Reference | Nothing | vbObject |
| String (variable length) | 10 bytes (80 bits) + string length | 0 to ~2 billion characters | “” | vbString |
| String (fixed length) | Length of string | 1 to ~65,400 characters | “” | vbString |
| Variant (numbers) | 16 bytes (128 bits) | Any numeric value as large as Double | Empty | vbVariant |
| Variant (characters) | 22 bytes (176 bits) + string length | Same as variant variable-length String | Empty | vbVariant |
Other Useful Links:
Please click on below links to have a knowledge on specific topics.