Microsoft Visual Basic training - Excel Visual Basic (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 from recording macros through to advanced form design. On the way you will learn how to write object-oriented programs and how to create loops and implement error-handling. Microsoft Excel macros are fun - let us show you why!

Excel Visual Basic training - Course Contents

The contents of our Excel Visual Basic 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 call or email us to talk through your options. We want you to be on the right Microsoft Visual Basic 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
Working with files (*)
  • Using FileSystemObjects
  • Working with files and folders
  • Using FileDialogs
Revision exercises (*)
  • Exercises for after the course

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

Excel Visual Basic training - Pre-requisites

Delegates should be experienced Excel users. No experience of progamming is needed, although delegates should enjoy the logical challenge of learning new computer systems.

Excel Visual Basic training - Schedule and Prices

Prices for this Microsoft Visual Basic 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 Visual Basic 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 Visual Basic training

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

All content � Wise Owl Business Solutions Ltd 2007.  All rights reserved.  Design by Branches.