Overview
This program provides instruction in the more advanced use of Excel Macros. It will take participants beyond our Excel - Macros with VBA Programming, and introduces techniques for high-end Excel users to better utilise the power of Excel.
Content
- Understand the Excel Object Model
- Use the Editor Toolbar
- A deeper look at variables
- Scope of variables, procedures and modules
- Call other procedures
- Parameter passing between procedures
- Work with arrays
- Work with different event types
- Create more advanced functions (optional arguments)
- Work with external data
- Work with text files
- Create better user forms
- Code to operate user forms
- Error trapping routines
- Better debug techniques
- Make Application Programming Interface (API) calls.
Learning Outcomes
Participants should be able to:
- Have a deeper understanding of the Visual Basics Editor (VBE) environment
- Work with variables
- Understand scoping
- Pass values between procedures
- Import data from external sources
- Create better user forms
- Use debug techniques
- Use other objects.