How do I run a macro every time a certain cell changes its value? There is an event called Worksheet_Change which is triggered when a value is entered (it will not fire when a formula result changes). One of the arguments to this event is 'Target' which is a reference to what changed. Since this event will occur whenever a value changes - you can use the target to see if it is the cell you are interested in:
Back again, for Lesson 4. In last month’s Lesson 3 we learned about writing our own Excel functions, as well as how to incorporate Excel built-in functions in our VBA code. This month, we will cover the exciting topic of creating your own forms!
Excel page User tips Developer tips Excel FAQs