
This Excel VBA tutorial explains how to use Worksheet.Change Event.
You may also want to read:
Excel VBA get value before Worksheet_Change event
Excel automatically refresh pivot table
VBA Excel Worksheet_Change Event
Excel predefines some popular actions that you would do on different Objects (worksheet, workbook, button, etc), those actions are called Event. For example, activating a worksheet is an Event, closing a workbook is an Event, clicking on a button is an event. Each Objec...
Read More