hi
use the worksheet change event
right click the sheet tab and from the popup select view code which will
bring up the vb editor
in the left combo box above the code window, select worksheet.
put your code there. it will fire whenever data changes on the sheet.

regards
FSt1
"ranswert" wrote:

How do I start a macro whenever the contents in a cell is added or changed?
Thanks