Excel 2007, Advanced (VBA) EX-021

Course Overview

Creating macros using the macro recorder and Visual Basic programming. Creating forms using the Microsoft Excel Forms toolbar. Creating user forms or more precisely, user interfaces.

Prerequisites

Knowledge of Microsoft Windows.

Syllabus

Day 1

Macro-Commands:

• Automating routine tasks;
• Running macros;
• Modifying macros;
• The Personal Macro Workbook and execution errors.

Introduction to VBA – Part 1:

• Why VBA?;
• Object properties and methods;
• Creating a procedure;
• Using objects;
• Variables and constants;
• The Function procedures.

Day 2

Introduction to VBA – Part 2:

• Specifying control structures;
• Exploring objects and managing errors;
• Using Excel or VBA functions or functions customized in VBA;
• Varied and interesting procedures;
• Practical tips for optimizing your code;
• Exercises.

User forms:

• Working with user forms;
• Manipulating the sheet’s controls;
• The code linked to the user form.

Excel Specifications and Limits.

Bibliography.

Web Sites.