Excel VBA

Delegates will gain a general knowledge of VBA to manipulate and improve processes using Microsoft Excel.

Target Audience

Designed for advanced users of Excel.

Prerequisites

Delegates should be experienced advanced level users of Microsoft Excel or have attended the Advanced Formulae and Functions and Validate and Summarise courses. This is a very fast paced course and a knowledge of recording macros is required.

Outline

What is Visual Basic for Applications?

An Introduction to Macros

Recording Macros

Running Macros

Understanding the Visual Basic Environment

The Visual Basic Editor

Understanding the syntax of your Macros

Editing Macros

Adding comments and documentation to your macros

Assigning VBA and Macros to keyboard shortcuts, icons and menus

With Statements

Managing Error Messages

Debugging Techniques

Working with Variables and Data Types

User Defined Functions

Understand Objects and Collections

Add conditions to your macros

Communicate with the user

Message boxes

Input Boxes

Working with return values

Repeating Actions in VBA – Loops

Fixed loops

Flexible Loops

Customise Menus and Toolbars

Automation with Macros

Create Custom Dialog Boxes

Book the course: Excel VBA

*
Number of Attendees

*
Salutation:

*
Firstname:

*
Last Name:

*
Email:

* Attendees Names:

Software Version:

* Telephone No:

Company:

How did you here about us:

Voucher Code:

Comments:

FROG would love to keep in touch about future offers and services we think you’ll like to hear about. To confirm you would like to receive this information by email, please tick the box. Don’t forget, you can also change your marketing contact preferences at any time by emailing training@frog.co.uk or by using the unsubscribe links which you’ll find on all our marketing emails. For further information please see our Privacy Policy