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. |