Duration
2 days
Lesson 1: Using Expressions, Variables, and Intrinsic Functions
- Understanding Expressions and Statements
- Declaring Variables
- Understanding Data Types
- Working with Variable Scope
- Using Intrinsic Functions
- Understanding Constants
- Using Intrinsic Constants
- Using Message Boxes
- Using Input Boxes
- Declaring and Using Object Variables
Lesson 2: Controlling Program Execution
- Understanding Control-of-Flow Structures
- Working with Boolean Expressions
- Using the If…End If Decision Structures
- Using the Select Case… End Select Structure
- Using the Do…Loop Structure
- Using the For…To… Next Structure
- Using the For Each…Next Structure
- Guidelines for use of Control-of-Flow Structures
Lesson 3: Working with Forms and Controls
- Understanding UserForms
- Using the Toolbox
- Working with UserForms Properties, Events, and Methods
- Understanding Controls
- Setting Control Properties in the Properties Window
- Working with the Label Control
- Working with the Text Box Control
- Working with the Command Button Control
- Working with the Combo Box Control
- Working with the Frame Control
- Working with Option Button Controls
- Working with Control Appearance
- Setting the Tab Order
- Populating a Control
- Adding Code to Controls
- Launching a Form in Code
Lesson 4: Working with the PivotTable Object
- Understanding PivotTables
- Creating a PivotTable Using Worksheet Data
- Working with PivotTable Objects
- Working with PivotFields Collection
- Assigning a Macro to the Quick Access Toolbar
Lesson 5: Debugging Code
- Understanding Errors
- Using the Debugging Tools
- Setting Breakpoints
- Stepping through Code
- Using Break Mode during Run mode
- Determining the Value of Expressions
Lesson 6: Handling Errors
- Understanding Error Handling
- Understanding VBA’s Error Trapping Options
- Trapping Errors with the On Error Statement
- Understanding the Err Object
- Writing an Error-Handling Routine
- Working with Inline Error Handling
Programme scope, delivery arrangements and suitability are confirmed during enquiry.