Excel VBA Training | Chicago & Los Angeles
Fast Facts
1 day
Max 6 students
9.00am to 4.30pm
One per student
Included
395.00
Excel - VBA
Course Description
This Excel VBA course is designed to give experienced Excel users proficiency in creating procedures that run in response to specific events, creating user forms to accept or display data, validating the data entry in user forms, and debugging and handling errors in code. Find out more about our other Microsoft Excel classes.
Target Audience
This Excel VBA course is aimed at experienced Excel users looking to automate many of the repetitive tasks that are part of spreadsheet development by apply the Visual Basic for Applications (VBA) programming language to Excel tasks. Students are expected to have completed Excel Level 3 or have equivalent experience prior to attending this class. Suitable for Excel 2003 and 2007 users.
Learning Objectives
Upon successful completion of this Excel VBA training course students will be able to:
- Understand Visual Basic for Applications (VBA) Terminology.
- Work with Object Properties and Methods.
- Attach Code to Events and Buttons.
- Using Variables, Procedures and Functions in VBA.
- Control Structures to Execute Code.
- Add User Forms and Controls.
- Validate User entries.
- Error Handling and Debugging.
Upcoming Classes
Chicago |
Mar, 2010 | Apr, 2010 | May, 2010 | Jun, 2010 |
| Excel 2007 - VBA | Mar 25 * | May 13 ! |
Los Angeles |
Mar, 2010 | Apr, 2010 | May, 2010 | Jun, 2010 |
| Excel 2007 - VBA | Mar 18 | May 20 |
* Class almost full ! Class guaranteed to run † Class is full
Course Outline
Visual Basic Editor
- Visual Basic Termimology
- Start the Visual Basic Editor
- Work with Object properties and methods
- Attach code to events and buttons
- Use Object Browser to get information about Objects
Programming Basics
- Use Variables of various Data Types
- Manipulate Data using Expressions
- Declare and use Variables of correct Scope
- Declare and use Procedures of correct Scope
- Create Sub and Function Procedures
- Call one Procedure from other
Control Structures
- Use Decision Structures to create procedures that execute code
- Use Loop structures to execute code repeatedly
Custom Dialog boxes
- Add a User Form to your project
- Add Controls to User Form
- Attach Handle Events to Controls
- Validate Data entered
Debugging and Error Handling
- Identify compile-time, run-time and logical errors
- Use the Debugging Tools
- Write Error-handling code to trap errors
Meet the Instructors
Rich
Rich has been creating custom software programs, and delivering tailored training classes for the past 13 years. His passion for instruction and his pursuit of all things technical, combine with his outgoing personality to provide an engaging and enthusiastic exchange of knowledge and ideas with his trainees. Software training for Rich is a labor of love. As he puts it, "When you love what you do, it's really not work after all!"
Thank you TC for this terrific learning experience."
