There is also the Worksheet_Change() function which will trigger when cells on the worksheet are changed by the user or by an external link. Note however that this event does not occur when cells change during a recalculation.