Excel VBA 2007 - Expert

Overview

About this course

Self-paced lessons on VBA in Excel 2007: the object model, recorded macros, the Visual Basic Editor and writing your own code.

Curriculum

Curriculum

10 modules

Introduction

Understanding Objects
Referencing Workbooks, Worksheets, and Cells

Displaying the Developer Tab
Setting Macro Trust within Excel
Recording a Macro
Running a Macro
Editing a Macro with the Visual Basic Editor

Examining the VBA Editor Menu and Toolbar
Setting VBA Editor Options
Reviewing the Project Explorer
Reviewing the Properties Window
Understanding the Object and Procedure Drop-Down Lists
Viewing the Immediate Window
Viewing the Object Browser

Understanding Functions and Procedures
Dimensioning Variables
Understanding Object Variables
Understanding Variables and Scope
Commenting Your Code
Creating Constants
Manipulating Data
Understanding Procedure Arguments

Using the InputBox() Function
Understanding the MsgBox() Function
Using String Functions
Using Date Functions

Using If/Then/Else
Creating a Select/Case Statement
Understanding Logical Operators
Creating For/Next Loops
Creating Do Loops
Creating While/Wend Loops

Understanding UserForms
Understanding Controls
Setting Control Properties
Referencing Controls in VBA Code
Responding to Events
Creating a Function to Open a UserForm
Development Tips

Understanding Logic Errors and Syntax Errors
Running Your Macro from the VBA Editor
Setting Breakpoints
Stepping Through Your Macro
Creating Watches
Adding Error Trapping

Course Recap

Who it's for

Who it's for

Excel 2007 users automating work.

Before you start

No formal prerequisites. Bring curiosity and a willingness to practise.