Microsoft Excel 2003 VBA Programming

Course Aims
To apply the Visual Basic for Applications (VBA) programming language to simplify and automate many of the repetitive tasks that are part of spreadsheet development.
Who Should Attend?
Existing experienced users of Microsoft Excel who are confident in their use of commands, functions and simple Macros, and who want to use Microsoft Visual Basic to enhance and automate their applications. Students enrolling in this course should have a solid knowledge of the topics taught in our Microsoft Excel 2003 Introduction, Intermediate and Advanced courses.
Course Outline: Microsoft Excel 2003 VBA Programming
Developing Macros
· Create a Macro with the Macro Recorder · Edit a Macro · Debug a Macro · Customize Toolbars, Menus, and Hotkeys
Formatting Worksheets
· Sort Data · Insert Rows and Columns · Insert Text · Format Text · Duplicate Data · Generate a Report
Creating an Interactive Worksheet
· Determine Dialog Box Type · Capture User Input
Working with Multiple Worksheets
· Insert, Copy, and Delete Worksheets · Rename Worksheets · Modify the Order of Worksheets · Print Worksheets
Performing Calculations
· Create User-defined Functions · Automate SUM Functions