VBA and macro fundamentals
- Origins of VBA
- Difference between VBA and macros
- Recording and editing macros
- Editing and managing macros
- Saving and calling macros
- Observing security settings
General programming techniques with VBA variables
- The different variable types
- Using variables
- Variable safety
- Calculating and working with variables
- Conditional statements
- Simple branching
- Multi-level branching
- Loops
- Iterative loop
- Conditional loops (pre-checked and post-checked)
- Procedures and functions
Debugging and error handling
- Types of errors
- Error prevention (various methods to stop errors occurring in the first place)
- Debugging (finding errors quickly and efficiently)
- Error handling
- Using breakpoints and bookmarks
- Displaying information about variables and constants
- Working with the Watch window
- Working with the Locals window
- Working with the Immediate window
The Excel object model
- Application, Workbook, Worksheet, Range
- Dialog boxes
- Accessing objects in MS Office applications
- Retrieving object properties
- Changing object properties
- Running object methods
Dialog boxes
- Using built-in dialog boxes
- Customising built-in dialog boxes
Data access
- Opening and editing files
- Importing data
Event-driven programming
- Responding to events
Tips & Tricks
Throughout the course, the trainer shows you small tips and tricks to make your everyday work with VBA easier.
