How to run an event upon changing the value of a specific cell?
 

I want to run an event or a mcaro only when a certain cell is changed.
i.e., if the cell A1 value is changed, then do such and such ...

How to run an event upon changing the value of a specific cell?
 

Right click on your sheet tab, view code. Paste this in and modify to suit:

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("A1")) Is Nothing Then Exit Sub

'Do something here

End Sub
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Wael Fathy" wrote:

I want to run an event or a mcaro only when a certain cell is changed.
i.e., if the cell A1 value is changed, then do such and such ...