home  : Computer  : Microsoft Office  : Excel

Training Provided by Training Connection

Excel VBA Training - Chicago

ABCDEFGH25.jpg" alt="Excel VBA Training Class" width="145" height="150" align="left" />

1. Excel 2003 VBA - $395 (1 day - instructor-led)

To find out more about this class please visit our website at http://www.trainingconnection.com or call 312.698.4475

Excel 2003 VBA

This 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.

What you will learn

• To 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

Outline

Unit 1: 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

Unit 2: 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

Unit 3: Control Structures

• Use Decision Structures to create procedures that execute code
• Use Loop structures to execute code repeatedly

Unit 4: Custom Dialog boxes

• Add a User Form to your project
• Add Controls to User Form
• Attach Handle Events to Controls
• Validate Data entered

Unit 5: Debugging and Error Handling

• Identify compile-time, run-time and logical errors
• Use the Debugging Tools
• Write Error-handling code to trap errors

Excel VBA Training Chicago - http://www.trainingconnection.com/microsoft-office/excel-training-vba.php

Training Avaliability and Delivery

This is primarily ilt training Computer Lab Work Contact Training Connection for more information

Course Level: advanced Schedule: 1 days Training Presented in: English

About Training Connection - Training Provider

More Training from Training Connection

• Access Training - Chicago
• Access VBA Training
• Acrobat Training
• AJAX Training
• Anger Management
• Business Etiquette
• Business writing
• Communication Training
• CSS Training
• Customer Service
• Dreamweaver Training Chicago
• Excel Training - Chicago
• Fireworks Training
• Flash Training
• HTML Training
• Illustrator Training
• InDesign Training
• Outlook Training
• Photoshop Training
• PHP MySQL Training
• PowerPoint Training Chicago
• Project Management
• Project Training
• QuickBooks Training
• Ruby on Rails Training
• Sales Training
• Supervisor Training
• Word Training