Excel VBA
This two-day Microsoft Excel VBA course takes you through Visual Basic for Applications in Excel from recording macros through to advanced form design. On the way you will learn how to write object-oriented programs and how to create loops and implement error-handling.
You should be an advanced user of Excel and ideally have attended Intermediate and Advanced level courses before attending this training.
Duration 2 Days
Automating Everyday Tasks
- How Visual Basic for Applications talks to Microsoft Excel
- Creating a simple macro
- Recording and editing macros
- Stepping through a macro
- Relative and absolute recording
- Assembling a project from multiple macros.
Introduction to Excel VBA
- Recording a macro in Excel
- Running a macro
- Editing a macro
Overview of Visual Basic Editor
- Creating modules
- Project window
- Properties window
Inputs and Outputs
- Selecting cells, ranges and objects
- Entering formulas and calculations
- Input and message boxes
Variables
- Assigning data to variables
- Declaring variables
- Data types
- Variable scope
- Constants
- Using option explicit
Control Structures
- If, then, select case, do, while, for and for each
Objects, Properties, Methods, Events and Error Handling
- Capturing errors
- Manipulating errors
Debugging
- Quick watch (for variables)
- Break points
- Debug window
Forms (dialog boxes)
- Command buttons
- Comboboxes (dropdowns)
- Tick boxes
- Radio buttons
- Form initialisation
Menus and toolbars
- Building custom menus
- Modifying the standard toolbars
- Creating custom tools & toolbars
Optional Extras (if required)
- Event triggered procedures
- Creating add-in applications
- Links to other applications
|
