change event procedure
 

Do you know how to adapt the code,

Private Sub Worksheet_Change(ByVal Target As Range)

to execute when one particular cell is changed rather than any cell in the
worksheet?

change event procedure
 

Ben,

To have it only look at cell A2:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address < "$A$2" Then Exit Sub
....


HTH,
Bernie
MS Excel MVP

"benb" wrote in message
...
Do you know how to adapt the code,

Private Sub Worksheet_Change(ByVal Target As Range)

to execute when one particular cell is changed rather than any cell in the
worksheet?

change event procedure
 

Private Sub Worksheet_Change(ByVal Target As Range)

if target.address= "$A$1" Then
'etc.
End If

End Sub

--

HTH

RP

"benb" wrote in message
...
Do you know how to adapt the code,

Private Sub Worksheet_Change(ByVal Target As Range)

to execute when one particular cell is changed rather than any cell in the
worksheet?