What is Data Types in VBA?

A data type specifies that which types of data, we are storing into Variable Name such as integer, string, variant, Date, Boolean etc. We use different kinds of VBA Data Types in our programming. There are available different types of Data Types in Visual Basic Programming. We use Data Types in our VBA programming as per our need. Data type has occupied memory as per their range of value. We can divide Data Types into two main categories, numeric and non-numeric data types.

Numeric Data Types

Following table displays the information about Numeric data types and their range of values in VBA Programming.

Type Range of Values
Byte 0 to 255
Integer -32,768 to 32,767
Long -2,147,483,648 to 2,147,483,648
Single -3.402823E+38 to -1.401298E-45 for negative values

1.401298E-45 to 3.402823E+38 for positive values.

Double -1.79769313486232e+308 to -4.94065645841247E-324 for negative values

4.94065645841247E-324 to 1.79769313486232e+308 for positive values.

Currency -922,337,203,685,477.5808 to 922,337,203,685,477.5807
Decimal +/- 79,228,162,514,264,337,593,543,950,335 if no decimal is use

+/- 7.9228162514264337593543950335 (28 decimal places).

data type in excel

Non-Numeric Data Types

Following table displays the information about Non-Numeric data types and their range of values in VBA Programming.

Type Range of Values
String (fixed length) 1 to 65,400 characters
String (variable length) 0 to 2 billion characters
Date January 1, 100 to December 31, 9999
Boolean True or False
Object Any embedded object
Variant (numeric) Any value as large as double
Variant (text) Same as variable-length string

data type in vba

What is Data Types in VBA?

What is Variable in VBA?

Leave a Reply

Your email address will not be published. Required fields are marked *