- GS-35F-0556S
- Toll Free 877.932.8228
Excel 2007: VBA Programming Training
Delivery Options
- Live eLearning (1 day): $245.00 (Register)
- Customized Onsite Training (1 day): Request a Proposal
| Class Date and Time |
Price
|
Register |
|---|---|---|
| Mar 18, 2010 10:00 AM - 5:00 PM ET | $245.00 or 1 vouchers | Register |
| Apr 15, 2010 10:00 AM - 5:00 PM ET | $245.00 or 1 vouchers | Register |
| May 13, 2010 10:00 AM - 5:00 PM ET | $245.00 or 1 vouchers | Register |
| Jun 10, 2010 10:00 AM - 5:00 PM ET | $245.00 or 1 vouchers | Register |
Class Description
Class Overview
This VBA programming for Excel 2007 training course is designed to give experienced Excel users proficiency in creating procedures that run in response to specific events, working with control structures, developing user forms to accept or display data, validating the data entry in user forms, and debugging and handling errors in code.
Class Goals
- Learn to use VBA within Microsoft Excel 2007.
Class Outline
- Visual Basic Editor
- Visual Basic for Applications
- Object programming
- The Object Browser
- Programming basics
- Data basics
- Scope of variables
- Scope of procedures
- Control structures
- Decision structures
- Loop structures
- Custom dialog boxes
- User forms
- Events
- Debugging and error handling
- Errors
- Debugging
- Error handling
Class Materials
All students receive a course manual or book and all the class examples.
Students in private onsite classes will also receive:
Class Prerequisites
Experience in the following areas is required:
- Expertise in Microsoft Excel 2007
Technical Requirements
Our computer technical requirements and setup process is easy, with support just a click away.
Like a class you would go to, but you don't have to go anywhere. More...
The trainer comes to you and delivers a class customized for your team. More...
Our least expensive option. You proceed through the course entirely at your own pace. More...
