Excel 2003 VBA Programming, 2nd Edition Study Guide

1-4188-9068-5 © 2007 Publish date: February 27, 2006 138 pages

Buy Now: $25.99

Course ID: excel-2003-vba-prog-2nd-sg

CBT Planet's selection of Microsoft Excel computer training books includes one designed for experienced Excel users who wish to learn how to incorporate VBA programming techniques into their spreadsheets. The Excel 2003 VBA Programming study guide is an excellent tool that has earned a rating of 4.8/5.0 in overall quality from ProCert Labs.

By choosing this course, you will gain proficiency creating procedures that run in response to specific events, as well as in creating user forms for accepting or displaying data, validating data entry, debugging techniques, and handling errors in code.

The Excel 2003 VBA Programming courseware introduces you to the VBA terminology and the Visual Basic Editor. You will learn specific methods to attach code to buttons and events, how to manipulate your data with expressions, receive input from users, use variables and procedures of correct scope, work with decision structures and loop structures, handle events, use debugging tools and much more.

This course is designed as a self-directed Microsoft Excel training course that you take at your own pace. The Excel 2003 VBA Programming courseware is ideal for advanced or Power Users of Excel who want to further control the use of spreadsheets through programming. You can take this course along with other Excel courseware or use it as a standalone training tool.

Course Objectives

By taking this course, you will learn Visual Basic for Applications terminology and how to work with the Visual Basic Editor. You will learn about object properties and methods, how to attach code to events and buttons, and using the Object Browser for getting information about objects.

You will also learn about variables, manipulating data with expressions, getting user input, declaring and using variables and procedures of correct scope, create Sub and Function procedures, and calling one procedure from another.

Other topics include creating procedures that execute code, using loop structures to execute code repeatedly, adding user forms and controls, handling events, and validating entry. You'll learn the difference between compile-time, run-time, and logical errors, how to use debugging tools, and how to write error-handling code.

Course Contents

Unit 1 introduces Visual Basic Editor

• Visual Basic for Applications
• Object Programming
• Object Browser

Unit 2 covers programming fundamentals

• Data
• Scope of variables
• Scope of procedures

Unit 3 discusses control structures

• Working with decision structures
• Using Loop structures

Unit 4 covers creating custom dialog boxes

• Working with user forms
• Working with events

Unit 5 discusses debugging and error-handling

• Errors
• Debugging
• Error-handling