Is there a change event for a specific cell?

No, not for a specific cell per se, but filtering to an individual cell is
quite easy to do. In the VBA editor, within the worksheet code window, click
the left-hand drop down and select Worksheet from the list; then click the
right-hand drop down and select Change from its list. Whenever any cell is
finished being edited, the Change event fires and the Target argument
contains a reference to the cell that was changed. Let's say you wanted to
run code whenever C3 was changed; you could do this...

If Target = Range("C3") Then
' Your code goes here
End If

Rick


"Edd" wrote in message
...
Is there a change event for a specific cell?

The title line should read:

Private Sub Worksheet_Change(ByVal Target as Range)


"Edd" wrote:

Is there a change event for a specific cell?

Thank you Rick and JLGWhiz. That's what I ended up doing and it works
succesfully. I appreciate this forum and you guys..

Ed.


"JLGWhiz" wrote:

The title line should read:

Private Sub Worksheet_Change(ByVal Target as Range)


"Edd" wrote:

Is there a change event for a specific cell?