Microsoft Excel Macros & VBA

Please reload

Please reload

Introduction to Macros and VBA

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

Working with Procedures

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

Objects, Properties, Methods and Events

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

Using Expressions, Variables and Intrinsic Functions

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

Controlling Program Execution

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

Debugging and Handling Errors

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

Working with Forms and Controls

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

Duration - 2 days

Best Training Ever!

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 - Real Equity for All

Bespoke Excel Macros e VBA

My learning experience was awesome

Perdinand Reagan - Subsea7

Excel Macros & VBA

The Trainer – Very positive + patient + helpful + thorough

Agnes Souza - Direct Wines

Excel Macros & VBA

Very nice and relaxed approach to teaching

Was definitely a good learning experience

Jerome Pupe - S5 Agency World

Excel Macros & VBA

Please reload