Planning Information
The duration of this course is 1 Day.
Description
The Visual Basic for Applications programming language is a powerful addition to all Office, and particularly useful in Microsoft® Excel®.
Intended Audience
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.
At Completion
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.
Prerequisites
Students should know how to create and save workbooks, create formulas, use basic functions.
Materials
Courseware Microsoft Office Excel 2007: VBA Programming
Course Outline
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
- Events
Lesson 5: Debugging and Error Handling
- Errors
- Debugging
- Error handling
- Debugging and error handling
This course is also available for private training. Please contact us at 610-321-3500 to learn more.
Register your interest now
