Computer and Business Skills training

Sign Up
Home / Excel / VBA

Excel Level 4 Course - Macros & VBA

Course Description

This instructor-led course covers automation and customation of Excel using macros and screen items (such as buttons and menus). Trainees learn how to write macros using VB code and assign macros to screen items.

Live face-to-face instructor. No minimum class size - all classes guaranteed to run!

Students are expected to have completed Excel Advanced or have the equivalent experience prior to attending this class. Suitable for Excel 2010/2013/2016 users.

View our full range of Microsoft Excel training classes, or see below for the detailed outline for Excel VBA.

1 Day | $450.00

Register button

Detailed course outline

  • Introduction and the Macro Recorder
    • Introduction
    • Demonstration
    • Recording a macro
    • Recording a macro with absolute references
    • The personal macro workbook
    • Assigning shortcut keys
    • Deleting macros
    • Recording a macro with relative references
  • Creating and Editing Macros With VBA
    • Macro storage concepts
    • The VBA program (the VB editor)
    • The program components
    • Storing and handling macros (modules)
    • Introduction to editing code
    • Copying and pasting procedures
    • Linking procedures together
    • Create and use a user-defined function
    • Auto-executable macros
  • Objects and Dialog Boxes
    • Introduction to objects
    • The VBA Object Browser
    • Using the object browser and searching it
    • Built-in Dialog Boxes
    • User defined dialog boxes (message boxes and input boxes)
  • Introduction to Controls
    • Worksheet controls
    • User forms
  • Selected VBA Procedures
    • IF...THEN...ELSE (Conditional Control Structure)
    • SELECT CASE (Branching)
    • The DO...LOOP control structure
    • The FOR...NEXT control structure
  • Additional exercises
    • Exercise 1: Case Changer Macros
    • Exercise 2: Change Object Properties
    • Exercise 3: Copy Macros
    • Exercise 4: Custom Menus
    • Exercise 5: Input Boxes
    • Exercise 6: Linking Macros
    • Exercise 7: Message Boxes (MsgBox)
    • Exercise 8: User Defined Functions

Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.



230 W Monroe St
IL 60606View Map

Guaranteed to Run Limited Seats Left

Class times: 9.00am to 4.30pm

Servicing Arlington Heights, Aurora, Bollingbrook, Chicago Loop,
Deerfield, Des Plaines, Evanston, Highland Park, Joliet, Naperville,
Schaumburg, Skokie, South Chicago and surrounding areas.

Other Cities

Request onsite training quote

Los Angeles

915 Wilshire Blvd
Los Angeles
CA 90017View Map

Guaranteed to Run Limited Seats Left

Class times: 9.00am to 4.30pm

Servicing Anaheim, Burbank, Covina, Downtown, Fullerton,
Irvine, Long Beach, Northridge, Pasadena, San Bernardino,
Santa Monica, Van Nuys, Ventura and surrounding areas.

Related courses

Why train with us?Need Group training quotation?Fresh Peet's Coffee brewed every day FREE Class Repeat with each course