search our courses:
Quick Navigation
Microsoft Excel 2007 VBA course
Download PDF version of Excel 2007 VBA course outline
Overview
This course is designed to teach delegates how to develop applications with Excel’s Visual Basic for Applications (VBA) Programming System, to build greater functionality into custom applications or to automate cumbersome everyday tasks.
Audience
Delegates who need to learn how to create sophisticated applications for data presentation using custom dialogue boxes and menus through use of structured macros and macro code.
Course Objectives
The objectives of the course are to:
- At the end of this course, delegates will be able to record macros, edit VBA code and build procedures which interact with the user.
Prerequisites
It is essential that delegates have attended an Excel Advanced Course or have a similar knowledge. An understanding of Visual Basic would be useful.
Course Contents (2 days)
- Getting Started
- Recording VBA
- Buttons to Run Macros
- Macro Security
- Visual Basic Editor
- Overview of Menus and Toolbars
- Project Explorer
- Local, Immediate and Watch Windows
- Short cuts
- Object explorer
- Addins to the Editor
- Programming Basics
- Objects, Properties and Methods
- Comments
- Code Layout
- Location of Code
- Subs, Functions and Events
- Excel Object Model
- Range Object
- Worksheet Object
- Workbook Object
- Events
- Add-ins
- Worksheet Functions
- Ribbons
- Using Custom UI Editor
- Adding New Ribbons
- Programming Structures
- Sub and Function Statements
- Decision Code
- If Statement
- Select Case Statement
- Loops
- Do Loop
- For Loop
- For Each Loop
- With Statement
- Msgbox and Inputbox
- Variables
- Naming Variables
- Types of Variables
- Using Parameters
- Variable Lifetime and Scope
- User-Defined Forms
- Basic Form Design
- Form Handling and Events
- Error Handling
- Trapping Errors
- Err Object
- Debugging Techniques
- Development Process
- Modular Code
- Flow Control
- Test Plans
- Gold Plating