Course curriculum

  • 1

    Course Introduction

    • VBA Course Introduction

    • Course Outline

    • Why Use VBA?

    • Case Study Scenario

  • 2

    Custom Formulas

    • Custom Formulas Start File

    • Session Objectives

    • How to Open VBA

    • A Tour of VBA

    • Create a Module

    • Enable Macros Notification

    • A Formula in Excel

    • A Basic Function

    • Making a Variable Dynamic

    • Application.Volatile

    • Future Proofing Our Code

    • Comments

    • Making Our Output Currency Dynamic

    • Session Recap

    • Session Summary

  • 3

    Errors and Exceptions

    • Errors and Exceptions Start File

    • Session Objectives

    • Using Breakpoints

    • Tracking Down an Error

    • Option Explicit & Types of Variables

    • Testing Option Explicit

    • Variable Types for Arguments

    • Code Order

    • Other Ways to Track Values

    • Trapping an Exception with On Error Resume Next

    • Exit Function & Colons

    • Session Recap

    • Session Summary

  • 4

    Finalize and Publish Functions

    • Finalize and Publish Functions Start File

    • Session Objectives

    • Currency Recap

    • Catching an Exception By Using an Indented IF

    • Setting Up Our Code to Handle Multiple Output Currencies

    • Output In Any Currency

    • Review the Final Function

    • Saving Our Function as an Add-in

    • Download a Colleague's File

    • Installing an Add-in

    • Preventing Add-in Code Conflicts

    • Session Summary

  • 5

    Events & Automations

    • Events and Automation Start File

    • Session Objectives

    • Why Use a Central Assumptions File

    • Create a Message Box Routine

    • Call the MSGBOX Each Time the Workbook Opens

    • Creating the Central Assumptions File

    • Setting Up A Code Framework

    • Pasting Data Back to the Workbook

    • Testing Our Code

    • How to Reference Another Workbook (Excel)

    • Creating a VBA Reference to Another Workbook

    • Using a VBA Reference to GET Value from Another File

    • Common Errors When Referencing Workbooks

    • Catching an Exception with an IF Statement

    • Ensuring the Update Happens Every Time the File Is Opened

    • For Each Loop

    • Adapting Our Loop

    • Session Summary

  • 6

    Working with Arrays

    • Working with Arrays Start File

    • Sessions Objectives

    • Setting Up Our Project

    • Working With Multiple Workbooks

    • Testing with STOP

    • Selecting a Sheet in Another Workbook

    • Assigning Values to an Array

    • Testing an Array

    • Gathering Data and Returning to This Workbook

    • Methods

    • Resize a Table

    • Populating a Table of Data

    • Loop Through Rows

    • Success or Failure Message

    • Using our Array of Data in our Model

    • Session Summary

    • COUNT - Code Quality Rating

  • 7

    Qualified Assessment

    • Qualified Assessment

    • Share Your Feedback

    • Course Completion