Excel VBA macros training course (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!

Click here to show prices, dates and venues for this course

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):

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

Click on any link above to show free exercises for the topic in question. Delegates should be comfortable with using Excel (no advanced knowledge is needed). No experience of progamming is needed, although delegates should enjoy the logical challenge of learning new computer systems. There will be a maximum of 6 people on each course, and each person will have their own computer.

Excel VBA macros training course (2 days)

Excel VBA macros training - Course Contents

Top menu

Microsoft Office

SQL Server training

.NET / SharePoint

Training venues

SITE MAP

Microsoft Office training and consultancy

SQL Server training and consultancy

.NET and SharePoint training

Computer training venues