Adobe Training
Acrobat Connect Training
Acrobat Training
Captivate Training
Dreamweaver Training
Flash Training
Flex Training
Illustrator Training
InDesign Training
Photoshop Training
Web Development
AJAX Training
CSS Training
HTML Training
JavaScript Training
PHP MySQL Training
Ruby on Rails Training
XML Training
Microsoft Office
Access Training
Excel Training
Outlook Training
PowerPoint Training
Project Training
Visio Training
Word Training
Business Skills
Anger Management Class
Business Communication
Business Etiquette Training
Business Writing Class
Change Management
Customer Service Training
Project Management Training
Sales Training
Supervisor Training
Time Management Training
QuickBooks
QuickBooks Training
Excel VBA Training | Chicago
Fast Facts
1 day
Max 8 students
9.00am to 4.30pm
One per student
Included
395.00
Excel 2003 - 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.
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.
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.
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!"
