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

W

Wael Fathy

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 ...
 
L

Luke M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Run macro upon cell edit 0
How to record changing value of a cell 1
Excel In Excel how can I block the contenent of a cell? 0
emptying the contets of a cell base on the value of another cell 3
macro to run in event of cell value <>"" 3
Default Cell value in changing environment 3
Maintain cell reference after value is moved 2
Email message on cell change event 1

Top