My sheet has feeds from an external source and keeps getting updated.. so the other cells (with different formula) which use the data need to be refreshed always. I dont want to use shift+f9 always.
Also when some value in the some cells (these have some formula in them) reach a particular value , a pop box has to come up and display the message
.

Now I wrote a macro for this, it autocalculates the cells using
Application.calculate

The thing is that there are several cells to be monitored and i have to simulatneously monitor them.. Any suggestions how to go about it?