Microsoft Excel Macros & VBA - classroom

Record and edit a Macro

Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects.

Use the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures

Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope

Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks

Create an error handling routine in case things go wrong with VBA code

Best Training Ever!

Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability.

Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All

The trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience..

Simon Harper - Lloyd's of London

My learning experience was awesome.

Perdinand Reagan - Subsea7

Very nice and relaxed approach to teaching. Was definitely a good learning experience.

Jerome Pupe - S5 Agency World

The Trainer – Very positive + patient + helpful + thorough

Agnes Souza - Direct Wines

Introducing Visual Basic for Applications

Recording a Macro

Naming conventions for Macro Procedures

Running a Macro

Absolute or Relative Cell Referencing

Saving and Opening Files with Macros

Making macros always available

Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes

Editing a Macro in the Visual Basic Editor

Understanding the Development Environment

Customising the Editor

Tips for General Typing in VBA

Using Visual Basic Help

Program Design

Understanding Modules

Naming Rules

Creating a Module

Understanding Procedures

Programming Macro Concepts

Creating a Subroutine

Creating a Function

Understanding Arguments

Exiting Procedures

Calling Procedures

Understanding Objects Properties, Methods, and Events

Navigating the Object Hierarchy

Understanding Collections

Accessing a Member of a Collection

Understanding Hierarchy

Using the Object Browser

Using the With Statement

Working with Properties

Working with Methods

Creating an Event Procedure

Reserved Macro Names

Understanding Expressions and Statements

Declaring Variables

Understanding Data Types

Determining the Value of Variables

Working with Variable Scope

Using Built-in VBA Functions

Understanding Constants

Using Message Boxes

Controlling the Answer to a Message Box

Using Input Boxes

Declaring and Using Object Variables

Understanding Control-of-Flow Structures

Using the If...End If Decision Structures

Nested If Statements

Using the Select Case ... End Select Structure

Using the Do ... Loop Structure

Using the For ... Next Structure

Using the For Each ... Next Structure

Guidelines for Use of Control-of-Flow Structures

Understanding Errors

Using Debugging Tools

Setting Breakpoints and Using Break Mode

Stepping Through Code

Trapping Errors with the On Error Statement

Understanding the Err Object

Working with Inline Error Handling

Writing an Error-Handling Routine

Understanding UserForms

Creating a Form

Displaying and Removing a Form

Aligning and Sizing Controls

Using the Toolbox

Working with a Form's Properties, Methods, and Events

Working with Form and Control Properties, Methods and Event

Setting the Tab Order

Populating a Control