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

  • Thread starter Thread starter Wael Fathy
  • Start date Start date
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 ...
 
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
 
You must log in or register to reply here.

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

Trying to run excel vba code when cell value changes from empty to entered value. 1
Using countif on non-consecutive cells 5
Excel Run macro upon cell edit 0
Excel In Excel how can I block the contenent of a cell? 0
"Save As" to XML file macro using a cell's value 0
want to track time while paste value in multiple column of same roe 1
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
How to Run a Macro from clicking a cell 11

Back
Top