Microsoft Excel 2007 training | Excel VBA macros (2 days)

Not only our best-selling course, but also one of our favourites. This two-day course takes you through Visual Basic for Applications in Excel, all the way from recording Excel VBA macros through to designing your own user forms. On the way you will learn what variables are, how to write object-oriented programs, how to create loops and much more besides. Microsoft Excel VBA macros are fun - let us show you why!

Excel VBA macros training - Course Contents

The contents of our Excel VBA macros course are as follows (any items marked with a * will be covered if time allows). If you aren't sure if this is the right course for you, please either click on one of the content headings below and try some exercises or call or email us to talk through your options. We want you to be on the right Microsoft Excel 2007 training course as much as you do!

Recording macros and buttons
  • Absolute and relative recording
  • Where macros can be stored
  • Assigning macros to buttons
Selecting cells
  • Selecting cells (absolute)
  • Selecting cells (relative)
  • Selecting to the end of a block
  • Selecting a range by its corners
The VB code editor
  • Using Project Explorer
  • Creating modules
  • Basic subroutines and comments
Messages and variables
  • Input boxes and message boxes
  • Declaring variables
  • Option Explicit
  • Scope of variables
  • Constants
Visual Basic explained
  • The Excel object model
  • Objects and collections
  • Methods and properties
  • Getting help in VBA
Loops and conditions
  • Simple IF conditions
  • Multiple IF and SELECT … CASE
  • Three main types of loop
Looping over collections
  • Object variables
  • Looping over collections
Event handling
  • Assigning macros to events
  • Cancelling events
Functions
  • Declaring functions
  • Passing arguments
Debugging and error handling
  • Setting breakpoints
  • Stepping through macros
  • ON ERROR statements
Forms
  • Drawing forms
  • Attaching macros to controls
  • Validating form input
Referencing other applications (*)
  • Links to Word or Access
  • Working with files and folders

To help see if this is the right course for you, you can see and download examples of our Excel VBA Macros courseware. You can also look at the differences between Microsoft Excel VBA Macros versions and see on which Excel VBA Macros version we currently train.

Excel VBA macros training - Pre-requisites

Delegates should be comfortable Excel (no advanced knowledge is needed). No experience of progamming is needed, although delegates should enjoy the logical challenge of learning new computer systems.

Excel VBA macros training - Schedule and Prices

Prices for this Microsoft Excel 2007 training course are as follows:

There will be a maximum of 6 people on each course, and each person will have their own computer. Please take a moment to see why our Microsoft Excel 2007 training courses are so different, then use our easy-to-use web-based or telephone booking system to book your course place. Alternatively, call (01457) 858877 or email our training co-ordinator.

Onsite Microsoft Excel 2007 training

In addition to our standard scheduled Microsoft training courses, we also offer onsite Microsoft Excel 2007 training. This allows you to create a Microsoft Excel 2007 training course uniquely tailored to the needs of your staff, covering only those aspects of Microsoft Excel 2007 which they need to learn.

Recommended sites: TechTutorials

All content copyright Wise Owl Business Solutions Ltd 2009.  All rights reserved.