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" <(E-Mail Removed)> wrote in message
news:91B0B983-F4A9-4FDF-9548-(E-Mail Removed)...
> 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?
> >
> >