Microsoft Excel 2007: Level 6 - Intermediate to VBA

Course Overview

Students who wish to attend this course must have a good knowledge of Excel and have attended the Microsoft Excel: Level 5 - Introduction to VBA course or have good personal experience at writing basic VBA code.

Delegates that attend a Microsoft training course are twice as motivated than those that don't?

Related Courses

• Microsoft Excel 2007: Upgrade New Features
• Microsoft Excel 2007: Introduction for Beginners (1 day)
• Microsoft Excel 2007: Visual Basic for Applications (VBA) Programming (2 day)
• Microsoft Excel 2007: Advanced (1 day)
• Microsoft Excel 2007: Intermediate (1 day)
• Microsoft Excel 2007: Intermediate (2 day)
• Microsoft Excel 2007: Advanced
• Microsoft Excel 2007: Formulae & Functions
• Microsoft Excel 2007: Charts, Pivot Tables & Macros
• Microsoft Excel 2007: Intermediate and Advanced Training Course

Audience

This course is aimed at people who want to explore further the VBA language and write VBA code so that future maintenance tasks can be carried out with the minimum of effort.

Skills Gained

Objectives: On completion of this course delegates will be able to:

• Refer to range objects using different types of code
• Understand and effectively use variables and arrays
• Create custom functions
• Test their code using VB Editor tools.
• Deal with potential errors in the execution of their sub procedures with error handling code
• Make their code more accessible by saving it as an Add-In.
• Improve the interactivity of their code with custom user forms.

Course Outline

Range Objects

• Referring to Ranges
• Collections
• The CurrentRegion Property
• The Offset & Resize Functions

Variables & Constants

• Declaring Variables
• Scope & Visibility
• Constants
• Arrays

User Defined Functions

• Using Excel Functions in VBA
• VBA Functions
• Function Procedures

Add-In applications

• Creating an Add-in
• Installing an Add-In
• Editing and Removing an Add-In

Debugging & Error Trapping

• Types of Error & Debugging
• Stepping a Procedure
• Break Mode
• Error Handling

UserForms & Built-in Dialog Boxes

• Using Built-In Excel Dialog Boxes
• Desgining a Userform
• Setting Control Properties
• Adding Form Events
• Displaying a Custom Userform