Computer Help Training: Excel Courses - Toronto - North York - Mississauga

Excel
Macros &
VBA Level 2

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.)

This course builds on Computer Help’s Macros & VBA Level 1. In it you will focus on two main Excel tasks that are best handled by macros. First you’ll look at the creation of custom dialog boxes and functions so that you can code sophisticated spreadsheets that are nevertheless still usable by basic Excel users. Second we’ll learn how to interact with and manipulate data in a spreadsheet.

Course Prerequisite: Solid understanding of all Excel Macros & VBA Level I topics.

Variable Tips

Public Vs Private Declarations

Extending the Scope of a Variable

Forcing Variable Declaration

Arrays

Introduction To Array Concept

Array Functions In Excel

Ranges And Arrays

Sorting An Array

Using Arrays In VBA to Sort Sheets Alphabetically

Select Case

Using Case Instead of IF

Select Case Constructs

Nesting Case Statements

Custom Functions

Why Create Functions

Create And Edit Functions

Declaring Functions

Arguments In Functions

Adding To Paste Function Dialog Box

Using Excel Events

Sequence of Events

Workbook Events (Activate/Deactivate, BeforeClose, BeforePrint, BeforeSave, NewSheet, Open, SheetActivate)

Worksheet Events (BeforeRightClick, UserForm Events

Working With Ranges

Move And Copy Fixed Or Variable Ranges

Determining Next Empty Cell

Determining Types Of Ranges

Copying Ranges from Sheet to Sheet, File to File

Returning Information About A Range

Analyzing Cells In A Range

Removing Empty Rows

Removing Rows based on Content

Determining If A Range Is Contained In Another Range

Procedure To Sort

Worksheets

Creating and Designing Forms and Custom Dialog Boxes

VBA Forms vs. Excel Forms

Create a Custom Dialog Box form

Combo Boxes

List Boxes

Check Boxes

Option Buttons

Labels

Using Event Handling to Display Forms

User Form Templates

Multi – Page Forms

Versions	Toronto
2007/2010/2013	Aug 14/15/16