Microsoft Excel 2007: VBA Introduction

Course Overview

Designed for experienced Excel users familiar with both basic and advanced features and functions. This course provides an overview of VBA and introduces users to basic VBA programming techniques.

Not sure whether this is the right Microsoft training course for you? Use our quick search bar to find the right Microsoft training course for you.

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

• Excel users familiar with both basic and advanced features and functions

Course Outline

Basics

• Excel VBA overview
• Understanding macro steps
• Modifying macro steps
• Storing values in variables
• Adding comments to your code
• Stepping through macros
• Getting help on macros
• Objects, properties and methods
• About Excel objects

Range object

• The Selection property
• The Range property
• Targetting cells
• Counting the cells in a selection
• Using the Offset statement
• Retrieving the value of a cell
• Retrieving a formula from a cell
• Setting the value of cells

Using Visual Basic

• Language structure
• Using variables
• Declaring variables
• Data types
• Making decisions
• If statements
• Looping structures

Interactivity

• Assigning a macro to a menu
• Assigning a macro to a toolbar
• Assigning macros to other objects
• Built-in dialogue boxes
• Using form controls