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...