Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2023/03/run-macro-when-cell-value-changes.zip

In this Microsoft Excel video tutorial I explain how to automatically run a macro using the worksheet change event in VBA. I explore three scenarios: 1) run a macro when a specific cell changes; 2) run a macro when any cell values changes within a range; 3) run a macro when a drop-down value changes.

Table of Contents:

00:00 - Introduction
00:25 - Single cell triggers macro
02:05 - Any cell within a range triggers macro
03:10 - Drop-down selection triggers macro
------------------------