Microsoft Excel VBA – Programming

$450

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.

Prerequisites

This course is designed for students who want to learn to automate repetitive tasks and-or develop self-running models and spreadsheets for others. The student should have significant Excel experience.

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