Excel VBA - How to Run Macro when Cell Changes

by Ben Thompson

In this video we look at how we can trigger a macro to run when a defined cell, range or entire sheet is updated.

To achieve this we use an existing change event in Excel "Worksheet_Change()" that by default will auto trigger when the sheet it is applied is updated.

We also have the ability to define a range so that this even only triggers if one of the cells in our desired range is updated.

Access our COMPLETE Excel Course HERE

VBA Playlist ► https://essentialexceluk.com/blogs/tutorials/tagged/vba

More Tutorials ► https://essentialexceluk.com/blogs/tutorials

Back to Tutorials