Introduction
  • Introduction
  • Download These Files First
Recording your First Macro
  • Recording your First Macro
  • Assigning your Macro to a Toolbar Button
  • Customising the Ribbon to Add your Macro Buttons
  • Editing your Macro Code 1
  • Using Relative References when Recording Macros
  • Saving a Workbook Containing a Macro
  • Editing your Macro Code 2
  • Adding a Button to the Worksheet to Run your Macro
Getting Started with VBA
  • Introducing the Visual Basic Editor
  • Writing your First Macro
  • Cleaning Recorded Code
  • Working with Method Arguments
  • Referring to Cells, sheets and Workbooks
  • Errors in VBA
  • Introduction to VBA Quiz
  • Recording and Editing Macros Challenge
  • Recording and Editing Macros Challenge Answer
Working with Variables
  • Using Variables
  • The Role of Option Explicit
  • Variable Scope
  • Using Object Variables
  • Using Variables Quiz
Making Decisions
  • If..Then..Else Statements
  • Select Case Statements
Looping
  • Conditional Loops
  • Using the Cells Object with a Loop
  • Conditional Loops - Updating an Inventory List
  • Counter Loops - Delete Blank Rows on a Worksheet
  • Counter Loops - Protect All the Worksheets in a Workbook
  • Collection Loops - Convert Selected Text to Uppercase
  • Nesting Loops - Updating an Inventory List 2
  • Make your Procedures Faster and Stop Interference
  • Looping Challenge
  • Looping Challenge Answer
  • Looping Challenge 2
  • Looping Challenge 2 Answer
Error Handling and Debugging
  • Debugging Code
  • On Error Resume Next
  • Creating Error Handlers
  • Using Multiple Error Handlers
  • The Err Object
  • Other Ways of Handling Anticipated Errors
User Interaction
  • Message Boxes - Updating an Inventory List 3
  • Input Boxes
  • Dialog Boxes - Using the Save As Dialog Box
Working with Files and Folders
  • Loop Through all Files in a Folder
  • Loop Through Specific Files of Type - List File Names on a Worksheet
  • Create Directories and Export as PDF
Working with Arrays
  • Introduction to Arrays – One-Dimensional Fixed Arrays
  • Two-Dimensional Arrays
  • Dynamic Arrays
UserForms
  • Creating a Userform
  • Opening and Closing a Userform
  • Adding Functionality to the Userform
  • Validating Data on a Userform
  • Userforms Challenge
  • Userforms Challenge Answer
  • Userforms, Arrays and Files & Folders Challenge
  • Userforms, Arrays and Files & Folders Challenge Answer
Running Procedures from Events
  • The Workbook Open Event
  • The Workbook Before Save Event
  • The New Sheet Event
  • The Selection Change Event
  • The Worksheet Change Event
Creating Function Procedures
  • Creating a Function Procedure
  • Optional Arguments and Data Types
  • Documenting your Function Procedures
  • Creating an Add-In
  • Function Procedures Challenge
  • Function Procedures Challenge Answer
Additional Lectures
  • Using Your Own Image for a Button on the Ribbon
  • Email an Excel Workbook as an Attachment using VBA
  • Create a Progress Bar on a Userform to See the Macros Progress
Conclusion
  • What Next
  • Bonus Lecture: Free Resources to Keep Learning VBA