Excel 2003 VBA Programming

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 2003 and Visual Basic for Applications.

Target audience

Students should have familiarity with personal computers and the use of the keyboard and mouse. They should have completed introduction, intermediate and advanced courses in Excel 2003 or have equivalent practical experience

Course content

Visual Basic Editor Visual Basic for Applications • Object programming • The Object Browser

Programming basics Working with data • Scope of variables• Scope of procedures

Control structures Using decision structures • Using loop structures

Working with custom dialog boxes User forms • Handling events

Debugging and error-handling Errors in code • Using debugging techniques • Error-handling

About Courseware Company :: Instructor-led training courseware :: Self-study solutions :: Buy online today