|
Synesis ~ Corporate Training Specialists in Montreal Cancellation Policy
Description: 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.
Course Outline
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 Site
Pre-Requisites: Microsoft Excel 2007 Intermediate.
Certificates offered: Certificate of completion
Duration Details: 2 days
9:00am - 4:30pm
Facility Location: Synesis Inc.
2075 University
5th Floor
Montreal
Quebec
Canada
H3A 2L1
| 
