The duration of this course is 1 Day. The list price is $375.00.
The Visual Basic for Applications programming language is a powerful addition to all Office, and particularly useful in Microsoft® Excel®.
The Excel VBA class is intended for students who wish to enhance their knowledge of Excel and utilize the power of macros to automate tasks.
Upon completion of this course, students will have a basic understanding of VBA and the macros produced by it. They will also leave with a set of working macros that cover basic logic and functionality.
Students should know how to create and save workbooks, create formulas, use basic functions.
Courseware Microsoft Office Excel 2007: VBA Programming
Lesson 1 : The Visual Basic Editor
- Visual Basic for Applications (VBA)
- Object programming
- The Object Browser
Lesson 2: Programming Basics
- Data basics
- Scope of variables
- Scope of procedures
Lesson 3: Control Structures
- Decision structures
- Loop structures
- Control structures
Lesson 4: Custom Dialog Boxes
- User Forms
Lesson 5: Debugging and Error Handling
- Error handling
- Debugging and error handling