Course duration
- 3 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.
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
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.