need a code to run macro if cell value is changed


Board Regular
Dec 22, 2008
Hi, I need a macro to run a piece of code which is already written. I have a cell IV1 a with a sum formula. When ever the total in IV1 changes then i want macro to run. I dont even want to touch cell IV1. I tried Worksheet-Change event, but it works only when i access the cell IV1 , It will not work when value is changed in IV1 when i not access that cell. Kindly help me.


Some videos you may like

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN


MrExcel MVP
Dec 9, 2008
Look at the Worksheet_Calculate event. This fires when a calculation is made. To have the code run only when the particular cell's return has changed, you would want to store the return val and check against it.

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Latest member

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...