07-26-2023, 08:17 PM
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.
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.