Course Overview
TOPYou will learn to use flow control, create custom dialogs, automate processes, and handle errors. Each lesson begins with a general overview of a feature and then shows how that feature works in each of the Office applications.
Scheduled Classes
TOPWhat You'll Learn
TOP- Learn to use the Select Case statement and the MsgBox function.
- Learn to work with the repetition structure.
- Learn to work with built-in dialog boxes.
- Learn to create custom dialog boxes.
- Learn to work with option button, check box, and list box controls.
- Learn to use Automation.
- Learn to trap errors.
Outline
TOP
Viewing outline for:
1. Using the Select Case Statement and the MsgBox Function
- Understanding Select Case Statement and MsgBox Function
- Using the Select Case Statement and the MsgBox Function in Excel
- Using the Select Case Statement and the MsgBox Function in Word
- Using the Select Case Statement and the Msgbox Function in Access
2. Working with the Repetition Structure and the With Statement
- Understanding the Repetition Structure and the With Statement
- Using the Repetition Structure and the With Statement in Excel
- Using the Repetition Structure and the With Statement in Word
- Using the Repetition Structure and the With Statement in Access
3. Advanced Repetition Structure and String Functions
- Using the String Repetition Structure and String Functions
- Using the String Repetition Structure and String Functions in Excel
- Using the String Repetition Structure and string Functions in Word
- Using the String Repetition Structure and String Functions in Access
4. Working with Custom Dialog Boxes
- Creating Custom Dialog Boxes
- Using Custom Dialog Boxes in Excel
- Using the Custom Dialog Boxes in Word
- Using the Custom Dialog Boxes in Access
5. Working with Option Button, Check Box, and List Box Controls
- Discussing the Dialog Box Controls
- Using the Option Button, Check Box, and List Box Controls in Excel
- Using the Option Button, Check Box, and List Box Controls in Word
- Using the Option Button, Check Box, and List Box Controls in Access
6. Automation
- Understanding the Automation Process
- Using Automation in Excel
- Using Automation in Word
- Using Automation in Access
7. Advanced Automation and Error Trapping
- Discussing Automation and Error Trapping
- Using Automation and Error Trapping in Excel
- Using Automation and Error Trapping in Word
- Using Automation and Error Trapping in Access
Prerequisites
TOPExperience in the following is required for this VBA class:
- Expertise in Microsoft Word, Excel and Access
- Basic VBA Skills as taught in Introduction to Visual Basic for Applications (VBA)