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

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