New Horizons Lexington KY Computer Training
New Horizons Computer Learning Center presents
 

Excel 2003 VBA - A Comprehensive Approach On-Site Training

This on-site training class is also available as Public Schedule Seminar.

This course is designed for proficient Excel 2003 users who wish to learn how to automate standard features and to develop programs in VBA.

Course Description/Agenda


Overview :
This course is designed for proficient Excel 2003 users who wish to learn how to automate standard features and to develop programs in VBA.

Objective :
At the completion of this course students should be able to: - create recorded macros is Excel. - use the macro recorder to create a variety of macros. - create and work with user-defined functions. - work with the main components of the VBA Editor window. - understand the Excel object model and use the Immediate window. - Create command procedures. - Create and use variables. - write code to manipulate Excel objects. - use a range of common programming techniques. - create a custom form complete with controls and event procedures. - create code to drive a custom form. - customize the menu system. - create procedures that start automatically.

Who Should Attend
This course is intended for people who wish to improve their knowledge and skills in the use of the software.

Lesson 1: Recorded Macros
Setting Macro Security Levels
Recording A Simple Macro
Running A Recorded Macro
Relative Cell References
Running A Macro With Relative Cell References
Viewing A Macro Module
Modifying A Recorded Macro
Recorded Macros Quick Reference

Lesson 2: Recorder Workshop
Preparing Data For An Application
Recording A Summation Macro
Recording Consolidations
Recording Divisional Macros
Testing Macros
Creating Objects To Run Macros
Assigning A Macro To An Object
Recorder Workshop Quick Reference

Lesson 3: User-Defined Functions
User-Defined Functions Theory
Creating Simple User-Defined Functions
Using User-Defined Functions
Using Multiple Arguments
Modifying A Function
Creating A Function Library
User-Defined Functions Quick Reference

Lesson 4: Using The VBA Editor
Opening And Closing The Editor
Working With The Project Explorer
Working With The Properties Window
Working With The Work Area
Working With A Code Module
Running Procedures From The Editor
Setting Breakpoints In The Editor
Stepping Through A Procedure
Using The VBA Editor Quick Reference

Lesson 5: Understanding VBA
VBA Terminology
Accessing The Excel Object Model
Using The Immediate Window
Working With Object Collections
Setting Property Values
Working With Worksheets
Using The Object Browser
Programming With The Object Browser
Understanding VBA Quick Reference

Lesson 6: Procedures
Creating A Command Procedure
Making Sense Of IntelliSense
Using The Edit Toolbar
Commenting Statements
Indenting Code
Bookmarking In Procedures
Procedures Quick Reference

Lesson 7: Using Variables
Creating And Using Variables
Implicit & Explicit Declarations
The Scope Of Variables
Procedure Level Scoping
Module Level Scoping
Passing Variables By Reference
Passing Variables By Value
Data Types
Declaring Data Types
Using Arrays
Using Variables Quick Reference

Lesson 8: Using Excel Objects
Application Methods And Properties
Workbook Methods And Properties
Viewing Excel And The Editor Together
Using Workbook Objects
Worksheet Methods And Properties
Using Worksheet Objects
Range Methods And Properties
Using Range Objects
Project Using Objects In Procedures
Using Excel Objects Quick Reference

Lesson 9: Programming Techniques
The MsgBox Function
Sending Messages To The User
InputBox Techniques
Using The InputBox Function
Using The InputBox Method
The IF Statement
Using IF For Single Conditions
Using IF For Multiple Conditions
The FOR NEXT Statement
Looping With Known Or Specified Iterations
The DO LOOP Statement
Looping With Unknown Iterations
Programming Techniques Quick Reference

Lesson 10: Creating Custom Forms
Creating A Custom Form
Adding Text Boxes To A Form
Changing Text Box Control Properties
Adding Label Controls To A Form
Adding A Combo Box Control
Adding Option Buttons
Adding Command Buttons
Running A Custom Form
Creating Custom Forms Quick Reference

Lesson 11: Programming Custom Forms
Initializing A Form
Closing A Form
Project Transferring Data From A Form
Running Form Procedures
Creating Error Checking Procedures
Running A Form From A Procedure
Programming Custom Forms Quick Reference

Lesson 12: Custom Menus
Creating A New Menu
Creating A Cascade Menu
Adding Menu Commands
Assigning Macros To Menu Commands
Removing A menu
Custom Menus Quick Reference

Lesson 13: Automatic Startup
Programming Automatic Procedures
Running Automatic Procedures
Automatically Starting A Workbook
Quick Reference.

 

More Seminar Information

New Horizons Computer Learning Center
New Horizons Lexington KY Computer Training

Delivery Method

On-Site Training On-Site Training

Also Available As

Seminar Seminar

 
Add to favorites Add to favorites
Email Email this page
 

On-Site Training
Information Request Form

Please complete the form for more information and/or a quote for this on-site class.

Name:

Email

Phone:

City and State

Company:

Number of students:
(at least 10 for consideration)

When do you want to hold the
seminar?

How long would you like for the
seminar?

Additional comments to trainer:

We value your privacy!