Course duration
- 5 days
Course Benefits
- Understand how the Visual Basic editor works in different Microsoft Office applications.
- Learn to work with the VBA object model.
- Learn to work with VBA object variables.
- Learn to work with string variables.
- Learn to work with date variables.
- Learn to work with numeric variables.
- Learn to use the selection structure.
- 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
- Introducing the Visual Basic Editor
- Using the Visual Basic Editor
- Using the Visual Basic Editor in Excel
- Using the Visual Basic Editor in Word
- Using the Visual Basic Editor in Access
- Working with the Object Model
- Using the Object Model
- Using the Object Model in Excel
- Using the Object Model in Word
- Using the Object Model in Access
- Working with the object variables
- Using object variables
- Creating and using object variables in Excel
- Creating and using object variables in Word
- Creating and using object variables in Access
- Working with string variables
- Using string variables
- Using string variables in Excel
- Using string variables in Word
- Using string variables in Access
- Working with date variables
- Discussing date variables
- Using date variables in Excel
- Using date variables in Word
- Using date variables in Access
- Working with numeric variables
- Discussing numeric variables
- Using numeric variables in Excel
- Using numeric variables in Word
- Using numeric variables in Access
- Using the selection structure
- Discussing the selection structure
- Using the selection structure in Excel
- Using the selection structure in Word
- Using the selection structure in Access
- 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
Instructor-led courses are offered via a live Web connection, at client sites throughout Europe, and at our Geneva Training Center.