Training Classes | Learning and Development Resources | Training Directory | New Training Seminars | New Training Providers | Site Map | Promote Training Seminars | Training Keywords | Training Seminars | Training Providers | Regions | Training Search | Advertise Training Seminars | Login
Provided by: Training Connection

Excel VBA Training

Click here for more information or to take this course

  home  : Computer  : Microsoft Office  : Excel

Get More Information
Search for Training
Find Your Genius!
What do you want to learn about?

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 labComputer Lab Work
Contact Training Connection for more information
Course Level:advanced
Schedule:1 days
Training Presented in:English

Related Keywords:  chicago   excel vba course   excel visual basic course   microsoft excel vba course   excel vb class   excel vba class 

Training Program Details


--

About Training Connection - Training Provider

Training Connection - Training Connection Training Connection provides training in the world's most popular desktop applications and in business skills. All our hands on training sessions are delivered by a qualified industry leading professionals. We keep our class sizes small so that each student is well looked after. www.trainingconnection.com Computer Courses include Photoshop Training, Dreamweaver...

More Training from Training Connection

Click here for more information or to take this course
Custom Search

Training Directory | New Training Seminars | New Training Providers | Search | Site Map | Promote Training | Login | Links


Connecting people who want to learn with people who love to teach
 Are you a Chicago training provider?
You could be on this page today - for FREE!