Excel
Macros &
VBA Level 1

3 Days (9am to 4pm)
$ 825. or 3
Tickets

Other Excel Course Levels

Introduction
Intermediate Level 1

Formulas

Intermediate Level 2
Functions
Advanced Level 1

Advanced Level 2
Macros & VBA Level 1

Macros & VBA Level 2

Macros & VBA Level 3
Upgrade from 2003

Register Now

Contact Us

View PDF Course Outlines for All
Excel Courses

 

Locations

Toronto
20 Queen Street West, Suite 3306
(
Toronto Eaton Centre)

North York
2 Lansing Square, Suite 505
(Hwy 401 & Hwy 404/DVP)

Mississauga
1087 Meyerside Drive, Unit 10
(
Dixie Rd. & Hwy. 401)

Newmarket
16635 Yonge Street, Unit 19
(
Yonge St. & Mulock Dr.)

 

While Excel is a very powerful and complete tool, you’ll sometimes encounter a situation where the program is missing some feature you really need. Whether it’s the ability to massage a list of data a particular way or make a sophisticated spreadsheet that is nevertheless safe to hand off to beginner users, a macro is the way to go.
In this course you will learn the basic concepts of macros, from simple recorded macros to sophisticated written VBA macros. It is intended for students who either have repetitive work to do in Excel and would like to teach the program how to do it, or who are in an informal support role and create spreadsheets for less-sophisticated Excel users. It also lays the foundation for students who need more formal and complete understanding of large-scale Excel customization and are moving on to the Level 2 and 3 courses.

 

Basic Macro Concepts

Macros And Sub Procedures

Limitations Of Recorded Macros

 

Recording Macros

Relative Referencing

Macro Options

Storing Macros

Editing A Macro

Debugging A Macro

Step Into, Step Over, Step Out

Run To Cursor

Seven Ways To Run A Macro; Adding To Toolbars, Creating Buttons, Etc.

 

Visual Basic

Defining Projects, Modules, Sub Procedures, Statements, And Events

The Visual Basic Editor

Views And Icons

Adding Comments

Checking Syntax Errors

Sub Procedures

Structures Of Sub Procedures

 

Objects

Working With

Object Names

Class

 

Properties

Common Properties

Using The With Command

Properties That Are Objects

 

Methods

Common Methods

Events

 

The Object Browser

Project/Library Box

Classes

 

Variables

Constants

Variable Types

String Variables

Date Variables

Declaring Several Variables

 

 

User Interaction

Input Boxes

Converting Input Box Answers

Message Boxes

Building Messages

Special Characters To Use When Concatenating

Message Box For Input

Status Bar Messages

 

Control of Flow

If … Then Statements

If  … Then … Elseif

Running Other Procedures From Within Procedures

If Statements With Message Boxes

For … Next Loops

Do While … Loops

 

Event Trapping

Auto_Open And Auto_Close

On Error Go To

Resume

Application Event Properties

Other Objects’ Event Properties

 

 

Versions   Toronto   North York
2007/2010/2013  

Aug 7/8/9

  Jun 10/11/12
    Mississauga   Newmarket

2007/2010/2013

 

 

Sep 16/17/18

 

Aug 21/22/23

 

Course Prerequisite: Required: Solid understanding of all Excel Introduction, and Intermediate Levels I & II topics. Recommended:  Knowledge of Excel Advanced topics.

 

  

Computer Training Courses / SoftSkills Seminars  / Access Database Development

Computer Help is a division of MPM Skills Development Inc.
Toronto, Ontario, Canada.

Phone: 416-494-4912, Fax: 416-494-9952

www.Computer-Help.ca

Question or Comment - Email Us