- Purpose and Basic Functionality
- Dim statement declares variables and allocates memory space
- Variables must be declared before use in code
- Dim statement does not assign values, only declares variables
- Syntax and Data Types
- Syntax includes Dim keyword followed by variable name and 'As' keyword
- Supports various data types like String, Integer, Double, Boolean
- Multiple variables can be declared on one line with commas
- Important Notes
- Variables can be declared without using Dim statement
- Default values assigned based on data type
- Variables declared in sub procedures accessible only within that scope
- Global variables must be declared in module's general declarations section
- VBA is case-insensitive but consistent casing recommended