Excel VBA Level 5

Duration: 1 Day

Course Code: XLL5

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

Click Here to view Course Dates

For more information on how to book, please click here.

Many thanks,

WWP & the Euroclear Team