Introduction to Microsoft Office Excel Macros
and VBA

1 Day
Version 2007

Course Description

This instructor-led course, through lecture and hands-on exploration, will introduce students to the Microsoft Office macro programming environment and show students how to use Visual Basic for Applications to create more complex macros. Microsoft Excel is used as the platform for this course, although the concepts apply across the entire Microsoft Office suite.

Prerequisites

It is strongly recommended that students have a strong familiarity with Microsoft Excel prior to taking this course.

Macros Management

Recording and Running Macros

Using a Personal Macro Workbook

Running Macros Using The Quick Access Toolbar

Running Macros Using Hotkeys

Running a Macro From Within Another Macro

Macro Security

Macro Security Setting Considerations

Understanding Digital Certificates and Signatures

Introduction to Visual Basic for Applications

Understanding the Visual Basic Editor Interface

Examining Module Design

Review of Excel Objects, Properties, and Methods

Editing a Macro Using the Visual Basic Editor

How to Debug a Macro

 

Using Loop Structures in VBA Code

Using a For...Next Statement

Using a Do...Loop Statement

Declaring and Using Variables in VBA

Understanding "With…End With" Syntax

Interactive Macros

Creating a Custom Message Box

Creating a Custom Input Box

Working With VBA Decision Making Code

The Select Case Decision Structure

The If...Then Decision Structure

Is this the right course for you? Please contact our office at (202) 747-5000 if you have any questions.

Other Helpful Links

Excel - Introduction Agenda

Excel - Intermediate Agenda

Excel - Advanced Agenda

Excel - Macro Recording and Programming

 

Find us
Find us on Facebook  Find us on Twitter

Register Online

Are you interested in a class for one or a few students? Consider taking a public class. View our public training schedule for dates.

Or, are you intersted in scheduling a private group class at your office or at Softek? Learn more about our private group training.

Top of Page
Softek Services, Inc.