Microsoft Excel VBA Introduction

Download PDF copy

‍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

Download PDF copy

‍

Excel Frequently Asked Questions

‍

Pricing from

Dedicated Courses

Virtual - £795 per day for up to 8 delegates

Onsite - £845 per day for up to 10 delegates

Public Schedule Courses - N/A

Notes

Onsite prices are for courses in London. For other locations, trainer expenses will apply.

All prices displayed are exclusive of VAT.

‍