Course Description

Course name

VBA for Excel 2007

Course code

VBAEXCEL2007

Audience

Excel users who wish to add Visual Basic GUI macros to their spreadsheets. This course is geared toward end-users.

Prerequisites

Folks that have a working knowledge of Excel and its basic functionality.

Objectives

Upon successful completion, the participant will be able to:

  • Create simple and complex macros using the macro recorder
  • Explore and object collections
  • Explore Window objects
  • Explore Windows using the Object Browser
  • Explore Range, Graphical, PivotTable and Chart Objects
  • Develop and execute Visual Basic Procedures
  • Return values from procedures
  • Code in Visual Basic language constructs.
  • Learn how to create simple loops
  • Handling errors within Visual Basic
  • Use Visual Basic reference tools
  • Create dynamic list boxes
  • Adding options to the dialog box
  • Create and populate forms

Duration

3 days

Delivery method

Classroom Interactive/workshop