Course Description
VBA is the programming Interface for Excel. It allows you to automate tasks and even control other applications such as PowerPoint and Access.
This class will be instructed using Microsoft Excel 2010. However, students can take this course using any of the following versions:
Agenda
Record A Simple Macro
Record a Macro
Run a Macro
Understand the VB Editor
Use the Menu Bar
Use the Standard Toolbar
Use the Project Explorer
Use the Properties Window
Understand the Code Window
Understand Code Window Options
Edit Code
Get Help
Use .CHM or .HLP Files
Close the Visual Basic Editor
Work with Objects
Understand the Object Browser
Understand Objects
Understand the Objects Hierarchy
Reference Objects
Understand Collections
Use the Editing Features
Use the Immediate Window
Use the Auto List
Use Auto Quick Info
Work with Variables
Understand Variables
Declare Variables
Understand Data Types
Store Values in Variables
Store Objects in Variables
Create Procedures and Functions
Understand Procedures
Use the Macro Recorder to Create Sub Procedures
Call Procedures from Procedures
Use Intrinsic Functions
Use Message Boxes
Use Input Boxes
Create Functions
Pass Arguments to a Function
Work with Conditional Statements
Understand Conditional Statements
Work with Decision Structures
Work with Loop Structures
Work with Forms and Controls
Understand UserForms
Use the Toolbox
Work with UserForm Properties
Events and Methods
Use the Properties Window
Understand Controls
Work with the Label Control
Work with the Text Box Control
Work with the Command Button Control
Work with the Combo Box Control
Work with the Frame Control
Work with the Option Button Controls
Add Functionality to Forms
Work with Control Appearance
Set the Tab Order
Populate a Control
Add Code to Controls
Launch Forms from Procedures
Use Pivot Tables
Understand PivotTables
Create PivotTables
PivotTable Arguments
Add Fields to PivotTables
Control Forms
Control PivotTables from a Form
Control a Form from a Custom Toolbar
Understand Debugging
Understand Errors
Debug Code
Debug Tools
Use the Locals Window
Use the Watch Window
Use Breakpoints