Key Training Logo

Microsoft Excel VBA Introduction

Course Code: XLL5

Duration: 1 Day

Course Aims:

This course is aimed at people who wish to make a start at learning the Excel VBA programming language, familiarising themselves with the concepts and practice of VBA programming, and understanding and using the relevant techniques.

Course Pre-requisites:

This course is aimed at people who wish to make a start at learning the Excel VBA programming language, familiarising themselves with the concepts and practice of VBA programming, and understanding and using the relevant techniques.

Course Objectives:

On completion of this course delegates will be able to:
▪ Use the Macro Recorder
▪ Understand how VBA code is stored and how to access it using the Visual Basic Editor
▪ Launch the Visual Basic Editor and use it to manage module sheets and code
▪ Get macros to run via shortcut keys, menus and buttons

Course Content:

Introduction and Objectives

Recording Macros
▪ What is a macro?
▪ Recording a Macro
▪ Running a Macro
▪ Saving a Workbook
Containing a Macro
▪ Opening a Workbook Containing a Macro
▪ Saving the Personal Macro Workbook

The Visual Basic Editor
▪ Launching the Visual Basic Editor
▪ Navigating the Visual Basic Editor
▪ Finding a Macro in the Visual Basic Editor
▪ Inserting a Module into a Workbook
▪ Copying a Module between Workbooks
▪ Renaming a Module Sheet
▪ Deleting a Module Sheet

Assigning Macros
▪ Running a Macro with Shortcut Keys
▪ Adding Custom Buttons to Run a Macro
▪ Removing Custom Buttons
▪ Creating and Editing a Worksheet Macro Button

Writing Procedures
▪ Frequently Used Excel Objects (Range, WorkSheets, WorkBooks)
▪ Methods and Properties
▪ Adding Arguments to Methods
▪ Selection or ActiveCell?
▪ The With … End With Block
▪ The Offset Property
▪ Dealing with a Runtime Error

Control Structures
▪ The If – Then Control Structure
▪ The If – Then – Else Control Structure
▪ Using ElseIf in a Control Structure
▪ The Select Case Control Structure
▪ Using a Do – Loop Statement

Data Variables
▪ What are Data Variables?
▪ Creating Data Variables and Assigning Values

Action planning

Review of Programme

Key Affiliations

 
Apprenticeships
ARC
RI Supplier Awards
European Union
Investors in people
Ofsted
Skills for health Quality Mark
AELP
Inspiring the future
ESFA
RI Top 500
5 Percent Club
Best Company 2019
Team Service Provider
REC Logo
Matrix
Youth Employment UK