Wise Owl

Excel VBA macros

Wise Owl
In Manchester and London

£695
+ VAT
Prefer to call the centre directly?
01618... More

Important information

Typology Workshop
Level Beginner
Location At 2 venues
Duration 2 Days
Start Different dates available
  • Workshop
  • Beginner
  • At 2 venues
  • Duration:
    2 Days
  • Start:
    Different dates available
Description

Not only our best-selling course, but also one of our favourites. This two-day course takes you through , 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!
Suitable for: This Excel VBA macros course is aimed at people who have a good existing working knowledge of Excel 2003, Excel 2007 or Excel 2010 and want to learn how to speed up their worksheets using macros.

Important information Facilities (2)
Where and when
Starts Location
Different dates available
London
40 Gracechurch Street, EC3V 0BT, London, England
See map
Different dates available
Manchester
Barlow House, Minshull Street, M1 3DZ, Lancashire, England
See map
Starts Different dates available
Location
London
40 Gracechurch Street, EC3V 0BT, London, England
See map
Starts Different dates available
Location
Manchester
Barlow House, Minshull Street, M1 3DZ, Lancashire, England
See map

Frequent Asked Questions

· Requirements

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.

What you'll learn on the course

Automating Excel
Macros
Selecting cells
Messages & variables
Visual Basic
Loops & conditions
Looping over collections
Event Handling
Functions
Debugging and error handling
Forms
Referencing other applications

Teachers and trainers (4)

Andrew Gould
Andrew Gould
Senior Trainer

Andy Brown
Andy Brown
Microsoft Trainer & Programmer

Sam Lowrie
Sam Lowrie
Trainer

Shaun Wantling
Shaun Wantling
Trainer

Course programme

Course ContentsRecording 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

If time

Referencing other applications
  • Links to Word or Access
  • Working with files and folders

Additional information

£695 + VAT for most venues (£850 + VAT for London)

Students that were interested in this course also looked at...
See all