Excel VBA Programming
Training Course Outline

1-day course

Course Aims

VBA courses for all versions of Excel - VBA for Excel 2010, VBA for Excel 2007, VBA for Excel 2003 and other versions.

This content has been designed for a one day classroom course. On course completion, students will be able to:

Use Visual Basic for Applications terminology; start Visual Basic Editor; work with object properties, methods and events; execute code by using a button; and use the Object Browser
Manipulate data by declaring variables and procedures of current scope to be used when and where you need them
Use decision structures to perform decision tasks and loop structures to perform repetitive tasks
Add a user form to your project, add controls to it, handle events associated with form controls, and validate data entry on forms
Identify errors in code, use the debugging tools and write error-handling code to trap errors

This course will help students to become proficient application developers by using the features of Microsoft Excel and Visual Basic for Applications.

The course is designed to give experienced Excel users proficiency in creating procedures that run in response to specific events, working with control structures, developing user forms to accept or display data, validating the data entry in user forms, and debugging and handling errors in code. The course is an effective combination of tuition by an experienced instructor together with hands-on exercises to give the trainee the experience of writing code and applying VBA. The course covers the following topics:

Module 1: Visual Basic Editor
Topic A: Visual Basic for Applications
Topic B: Object programming
Topic C: The Object Browser

Module 2: Programming basics
Topic A: Data basics
Topic B: Scope of variables
Topic C: Scope of procedures

Module 3: Control structures
Topic A: Decision structures
Topic B: Loop structures

Module 4: Custom dialog boxes
Topic A: User forms
Topic B: Events

Module 5: Debugging and error handling
Topic A: Errors
Topic B: Debugging
Topic C: Error handling