Use the Change event in the worksheet code module. Right click the sheet tab
for the sheet where you want the code to execute, then click on View Code in
the pop up menu. This opens the worksheet code module. At the top of the
code window you will see General and Declarations in two smaller windows.
Click on the General window first, then click Workbook, then select "Change"
from the drop down list. You should then see the two lines below:

Private Sub Worksheet_Change(ByVal Target As Range)

End Sub

The code to be executed for any change to the page can be put between these
two lines.

"ranswert" wrote:

Is there a way to run a macro each time a cell contents are added or changed?
Thanks

I should have said that the code would only evaluate the changes of cell C3.
The evaluation will include the value of cell B2, if you put a value in cell
B2.

"ranswert" wrote:

Is there a way to run the code only when a certain cell is changed? Not when
any cell on the sheet is changed

"JLGWhiz" wrote:

Use the Change event in the worksheet code module. Right click the sheet tab
for the sheet where you want the code to execute, then click on View Code in
the pop up menu. This opens the worksheet code module. At the top of the
code window you will see General and Declarations in two smaller windows.
Click on the General window first, then click Workbook, then select "Change"
from the drop down list. You should then see the two lines below:

Private Sub Worksheet_Change(ByVal Target As Range)

End Sub

The code to be executed for any change to the page can be put between these
two lines.

"ranswert" wrote:

Is there a way to run a macro each time a cell contents are added or changed?
Thanks