Does each cell have its own change event?

[Paladyr]

I have one cell that when a user makes a change to it, I want to run some code. Right now I am using the selectionchange event of the worksheet but I would rather use the change event of just this one cell. Can this be done? thanks!

 

[ETID]

Sustitute your cell row and col numbers for the 3's in the example below and the name of the sub to run if condition is true in place of "do_stuff"




Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Row <> 3 Or Target.Column <> 3 Then Exit Sub Else do_stuff

End Sub

 

[Paladyr]

I guess that is the only way to do it, thanks!