Cell Change Event
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?
|