Course duration
- 2 days
Course Benefits
- 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.
Course Outline
- 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
- 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
- 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
- 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
- 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
- Automation
- Understanding the Automation Process
- Using Automation in Excel
- Using Automation in Word
- Using Automation in Access
- 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
Class Materials
Each student will receive a comprehensive set of materials, including course notes and all the class examples.
Experience in the following is required for this VBA class:
- Expertise in Microsoft Word, Excel and Access
- Basic VBA Skills as taught in our introductory course
Instructor-led courses are offered via a live Web connection, at client sites throughout Europe, and at our Geneva Training Center.