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
Excel Frequently Asked Questions
