QP School
Datatypes in VBA - Printable Version

+- QP School (https://qomplainerzschool.lima-city.de)
+-- Forum: Tutorials (https://qomplainerzschool.lima-city.de/forumdisplay.php?fid=3)
+--- Forum: Excel VBA Tutorials (https://qomplainerzschool.lima-city.de/forumdisplay.php?fid=48)
+--- Thread: Datatypes in VBA (/showthread.php?tid=5203)



Datatypes in VBA - Qomplainerz - 07-26-2023

Datatypes define the type of data a variable can hold. VBA supports various datatypes, including:

6.1. Integer:
Used to store whole numbers between -32,768 to 32,767.

6.2. Long:
Used to store larger whole numbers between -2,147,483,648 to 2,147,483,647.

6.3. Single:
Used to store single-precision floating-point numbers with decimals.

6.4. Double:
Used to store double-precision floating-point numbers with decimals.

6.5. Boolean:
Used to store True or False values.

6.6. String:
Used to store text or alphanumeric data.

6.7. Date:
Used to store date and time values.