Microsoft Excel VBA Introduction

MODULE 1: Recording and Running Macros in Excel

Learning outcomes:

Create simple macros using the macro recorder and run them from shortcuts or buttons on the ribbon

Topics covered:

• Setting Excel Macro Options
• Record and Run Simple Macros
• Assign Macros to the Quick Access Toolbar

MODULE 2: Introduction to the Excel VBA Editor

Learning outcomes:

Use the VBA Editor to navigate projects and explore object properties. Create, copy and import/export modules

Topics covered:

• Starting the Visual Basic Editor
• Using the Project Explorer
• Using the Properties Window
• Creating, Importing and Exporting Modules
• Explore Recorded Macros

MODULE 3: Creating Procedures and Functions

Learning outcomes:

Create simple macro procedures in code that use variable to store data and communicate with the user

Topics covered:

• Creating Sub and Function Procedures
• Declare and Use Variables
• Displaying Message to the User
• Getting Input from the User

MODULE 4: Working with the Excel Object Model

Learning outcomes:

Explore a variety of ways our code can manipulate data within cells, create and navigate around worksheets and workbooks

Topics covered:

• Understanding Objects, Properties and Methods
• Referencing Cells and Ranges
• Gathering Cell and Range Information
• Using the Offset Method
• Using the Resize Method
• Using With Blocks
• Referencing Workbooks and Worksheets

MODULE 5: Controlling Program Flow

Learning outcomes:

Using decision making and looping structures to control the way your program works

Topics covered:

• Using the IF Statement
• Using the Select Case Statement
• Using For Next Loops
• Using Do Loops
• Using For Next Loops