Data types in VBA

Data TypeDescription
Byte0 to 255
BooleanTrue or False(1 or 0)
Integer-32768 to 32767
Long (long integer)-214,483,648 to 2147,483,647
Single (Six decimal places)
Double (Fourteen decimal places)
Currency (Four decimal places)
Decimal (28 places to right of the decimal point0)7.92….
String0 to about 2 billion charachters
DateJanuary 1, 100 to December 31,
ObjectA Object reference (e.g., a worksheet, table, form)
Variant(Number)Same as Double data type
Variant(string)Same as for String data type

if we don’t declare a data of particular type its considered as variant.

Previous
Next