Excel 2002 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 2002 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 2002 or have equivalent practical experience.

Course content

Using Visual Basic Editor Visual Basic for Applications • Working with objects, properties, methods, and events • Using the Object Browser

Programming basics Working with data • Understanding scope

Controlling program flow Using decision structures • Using loop structures

Working with custom dialog boxes Creating custom dialog boxes • Handling events

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

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