Excel 2007: VBA Programming Training
Delivery Options
- Live Online Training - Public Class (): $245.00 (Register)
- Customized Onsite Training (1 day): Request a Proposal
| Class Date and Time |
Price
|
|
|---|---|---|
|
$245.00
or 1 vouchers
voucher
|
||
| $245.00 or 1 vouchers voucher | ||
| $245.00 or 1 vouchers voucher | ||
| $245.00 or 1 vouchers voucher | ||
| $245.00 or 1 vouchers voucher | ||
| $245.00 or 1 vouchers voucher | ||
| $245.00 or 1 vouchers voucher | ||
| $245.00 or 1 vouchers voucher | ||
| $245.00 or 1 vouchers voucher | ||
| $245.00 or 1 vouchers voucher |
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
Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.
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.
- Onsite and Instructor-led Online course technical requirements and setup instructions.
- WebEx system requirements for Instructor-led Online delivery option.
of Live Online Training:
Recent Blog Articles
Data Types in VBA
Posted on Nov 30, 2010 by Connie
When declaring variables in VBA, you also assign a data type. But there is a trick to it: you want to choose a data type that uses the least amount of ...
Custom icons to run Macros in Microsoft Word 2003
Posted on May 19, 2010 by Connie
Have you ever wanted to attach a Macro to a button on the toolbar in Microsoft Word? Maybe you have and have seen the images that are provided for you. ...
VBA Variables Rules and Conventions
Posted on Apr 27, 2010 by Connie
What is a variable? Think of it this way, a variable is like a little box in your computer’s memory. The little box, the variable, will have a name. ...
Option Explicit in VBA
Posted on Apr 13, 2010 by Connie
You have probably opened the VB Editor in Access, Word, or PowerPoint, and seen Option Explicit at the top of the code window. But what does it mean? Option ...
Webucator is a Registered Education Provider (R.E.P.) approved by PMI to issue professional development units (PDUs) for our training courses.