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 ModelLearning 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