This will change the value in Range("A1") based on the value
of cell C3 only. The A1 value will be eithe 1 or 2.

Private Sub Worksheet_Change(ByVal Target as Range)
Set Target = Range("C3")
If Target.Value Range("B2") Then
Range("A1").Value = 1
Else
Range("A1").Value = 2
End If
End Sub


"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