Microsoft Office 2007 VBA: Introduction to VBA in Office 2007

Course Overview

In this course you will learn the fundamental skills to enable you to use the Visual Basic for Applications (VBA) programming language to simplify or automate activities in the Microsoft Office 2007 environment.

NOTE that Microsoft Excel 2007 is used as the key application during the course.

If you have a question about this Microsoft training course, call one of our advisors who will be happy to help answers any queries you may have.

Related Courses

• Microsoft Office 2007: Experience the 2007 Microsoft Microsoft Office: System
• Microsoft Office 2007: Deploying Microsoft Office 2007 Professional Plus
• Microsoft Office 2007: Streamlining Tasks for Improved Productivity
• Microsoft Office 2007: Upgrade/New Features
• Microsoft Office 2007: Upgrade to MS Office 2007
• Microsoft Office 2007: Advanced VBA
• Microsoft Office Power Point 2007/10 Smart og Avansert
• Microsoft Office InfoPath 2007 3 Day Course
• Microsoft Excel 2007: Upgrade New Features
• Microsoft Excel 2007: Introduction for Beginners (1 day)

Audience

Students looking to gain the skills necessary to apply VBA to develop macros, create user-interactive macros, and perform custom calculations. It is often the case that you work with Office files that include Macros and this course will introduce the VBA programming language together with how to navigate within the VBA environment.

Skills Gained

After completing this course, students will be able to:

• Develop macros
• Format and navigate within worksheets
• Create an interactive workbook
• Perform custom calculations
• Create a VBA form
• Control macro flow
• Debug the code and handle errors

Prerequisites

Delegates should be able to:

• Record macros
• Comprehensive understanding of the difference between absolute and relative references
• Format worksheet and workbooks
• Sort and filter data
• Create charts
• Knowledge of functions, e.g. SUM, IF, VLOOKUP

Course Outline

Lesson 1: Getting Started

• Introducing Visual Basic for Applications
• Recording a Macro
• Running a Macro
• Adding Macros to Keyboards Shortcuts, Buttons and Illustrations
• Editing a Macro in the Visual Basic Editor
• Understanding the Development Environment
• Tips for using QuickInfo and General Typing in VBA
• Using Visual Basic Help
• Closing the Visual Basic Editor

Lesson 2: Working with Procedures

• Program Design
• Understanding Modules
• Creating a Standard Module
• Understanding Procedures
• Multiple Macro Concepts
• Creating a Subroutine
• Creating a Function
• Understanding Arguments
• Exiting Procedures
• Calling Procedures

Lesson 3: Understanding Objects, Properties, Methods and Events

• Understanding Objects
• Navigating the Object Hierarchy
• Understanding Collections
• Using the Object Browser
• Using the With Statement
• Working with Properties
• Working with Methods
• Creating an Event Procedure

Lesson 4: Using Expressions, Variables and Intrinsic Functions

• Naming Rules
• Understanding Expressions and Statements
• Declaring Variables
• Understanding Data Types
• Working with Variable Scope
• Passing Values between Procedures
• Using Intrinsic Functions
• Understanding Constants
• Using Intrinsic Constants
• Using Message Boxes
• Controlling the Answer to a Message Box
• Using Input Boxes
• Declaring and Using Object Variables

Lesson 5: Controlling Program Execution

• Understanding Control-of-Flow Structures
• Working with Boolean Expressions
• Using the If...End If Decision Structure
• Using the Select Case...End Select Structure
• Using the Do...Loop Structure
• Using the For...To...Next Structure
• Using the For Each...Next Structure
• Guidelines for use of Control-of-Flow Structures

Lesson 6: Working with Forms and Controls

• Understanding UserForms
• Using the Toolbox
• Working with Form Properties, Methods, and Events
• Understanding and Setting Control Properties
• Working with Form Controls
• Setting the Tab Order
• Populating a Control
• Adding Code to Controls
• Launching a Form in Code

Lesson 7: Debugging Code

• Understanding Errors
• Using Debugging Tools
• Setting Breakpoints
• Stepping through Code
• Using Break Mode During Code Execution
• Determining the Value of Expressions

Lesson 8: Handling Errors

• Understanding Error Handling
• Understanding Error Trapping Options
• Trapping Errors with the On Error Statement
• Understanding the Err Object
• Working with Inline Error Handling
• Writing an Error-Handling Routine