Introduction to Visual Basic for Applications (VBA)
Delivery Options
- Live Online Training - Public Class (): $1,185.00 (Register)
- Customized Onsite Training (3 days): Request a Proposal
| Class Date and Time |
Price
|
|
|---|---|---|
|
$1,185.00
or 3 vouchers
vouchers
|
||
| $1,185.00 or 3 vouchers vouchers | ||
| $1,185.00 or 3 vouchers vouchers | ||
| $1,185.00 or 3 vouchers vouchers |
Class Description
Class Overview
In this introductory Visual Basic for Applications (VBA) training course, you will learn how to manipulate objects in Word, Access and Excel with VBA. Specifically, you will learn how to use the Visual Basic editor, work with the object model, create and use variables, and use the selection structure.
Each lesson of the class begins with a general overview of a feature and then shows how that feature works in each of the Office applications.
Class Goals
- 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.
Class 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 in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.
Class Prerequisites
Experience in the following areas is required:
- Expertise in Microsoft Word, Excel and Access
Technical Requirements
Our computer technical requirements and setup process is easy, with support just a click away.
Client Success
Join The Team
- Learn how you can become a Webucator Trainer
- Career Opportunities
Locations
- Where We've Trained
- We have trainers all over North America.
Compare Us
Recent Blog Articles
Data Types in VBA
Posted on Nov 30, 2010 by Connie
When declaring variables in VBA, you also assign a data type. But there is a trick to it: you want to choose a data type that uses the least amount of ...
Custom icons to run Macros in Microsoft Word 2003
Posted on May 19, 2010 by Connie
Have you ever wanted to attach a Macro to a button on the toolbar in Microsoft Word? Maybe you have and have seen the images that are provided for you. ...
VBA Variables Rules and Conventions
Posted on Apr 27, 2010 by Connie
What is a variable? Think of it this way, a variable is like a little box in your computer’s memory. The little box, the variable, will have a name. ...
Option Explicit in VBA
Posted on Apr 13, 2010 by Connie
You have probably opened the VB Editor in Access, Word, or PowerPoint, and seen Option Explicit at the top of the code window. But what does it mean? Option ...