Visual Basic for Applications (VBA)programming language can extend the functionality of Excel. This course is intended for delegates looking to gain the skills necessary to apply VBA to develop macros, format worksheets, create user interactive macros, work with multiple worksheets, and perform calculations.

You will learn to write macros to accept user input, read to and write from cells, manipulate data and write custom functions. Exercises will be given to delegates to gain an understanding of the topics being covered.

This short course is ideal for those with a good knowledge of MS Excel and would like to add additional functionality. No programming knowledge is required.

‍

No previous programming experience is required but an expert level of Excel use is assumed.

Participants need to be comfortable using Excel functions including nesting and using the IF function.

Course Content

Introducing Visual Basic for Applications

·        Displaying the Developer Tab in the Ribbon

·        Recording a Macro

·        Saving a Macro-Enabled Workbook

·        Running a Macro

·        Editing a Macro in the Visual Basic Editor

·        Understanding the Development Environment

·        Using Visual Basic Help

·        Closing the Visual Basic Editor

·        Understanding Macro Security

Working with Procedures and Functions:

·        Understanding Modules

·        Creating a Standard Module

·        Understanding Procedures

·        Creating a Sub Procedure

·        Calling Procedures

·        Using the Immediate Window to Call Procedures

·        Creating a Function Procedure

·        Naming Procedures

·        Working with the Code Editor

Understanding Objects:

·        Navigating the Excel Object Hierarchy

·        Understanding Using the Object Browser

·        Working with Properties

·        Using the With Statement

·        Working with Methods

·        Creating an Event Procedure

·        Using Expressions, Variables, and Intrinsic Functions:

·        Understanding Expressions and Statements

·        Declaring Variables

·        Understanding Data Types

·        Working with Variable Scope

·        Using Intrinsic Functions

·        Understanding Constants

·        Using Intrinsic Constants

·        Using Message Boxes

·        Using Input Boxes

·        Declaring and Using Object Variable

Controlling Program Execution:

·        Understanding Control-of-Flow Structures

·        Working with Boolean Expressions

·        Using the If…End If Decision Structures

·        Using the Select Case…End Select Structure

·        Using the Do…Loop Structure

·        Using the For…To…Next Structure

·        Using the For Each…Next Structure

·        Guidelines for use of Control-of-Flow Structures

Prerequisites

No previous programming experience is required but an expert level of Excel use is assumed.

Who should attend?

This course has been designed for users familiar with recording and editing basic macros in Excel who want to go further in automating and customising Excel using VBA – Visual Basic for Applications.

Certification

On completion of this one-day training course, you will receive your Certificate of Attendance. Please note certificates are issued at the close of the training course to participants on completion of the course. This course may qualify for CPD points. Please check directly with your association or awarding body to see how many points they will award.

Cost

This course costs €485 (normal rate is €585).PLEASE NOTE THE EARLY BIRD RATE CLOSES 3 WEEKS PRIOR TO COURSE DATE. The course cost includes all course documentation and Certificate of Attendance.