Macro that monitors cell, then pauses and sets other cell value

[donpost]

Apologies to the mods for not reading rule 1, I will now attempt to restate my problem.

What I have:

A workbook with multiple sheets. Each sheet is formatted the same. Information on the sheets is updated approximately once per second by an outside program. Sheets are added and removed manually by the user as new ones are required, and old ones are finished with.

What I need:

At any time, I would like to be able to "push a button" on any particular sheet and have the following occur:

Constantly monitor cell H7 say.
If value of H7 goes above a certain amount, stop monitoring H7 and wait 30 seconds, then enter certain calculated values in certain cells on the sheet.

I need this to be able to occur on many different sheets at once. For example "Sheet1" could be in the monitoring H7 stage, "Sheet2" could be in the timer stage, "Sheet3" could be finished, "Sheet4" could be unstarted.


Thank you for any help you can provide

[zbor]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.