loop to stop and wait for cell value change.

I'm very new to this, but I have a simple macro that is working largely as intended. I want it to look at a cell, and give the user an error message if the cell value is less than or equal to a referenced cell. I want it to keep checking the cell, but I need to give the user an opportunity to change the value before each check. Can I set up some trigger that activates when the user enters data into the cell?

This is my code:

Please Login or Register  to view this content.

I appreciate any help.

Well, I've partially found my solution. I modified the code as follows:

Please Login or Register  to view this content.

This works great as long as I keep entering values into cellB2 that cause the message box to appear. Once I enter a value that is greater than the value in cell A2, then spreadsheet accepts the value, then after a few seconds, Excel freezes.

Any ideas why?

HI

Try

Please Login or Register  to view this content.

rylo

I do want the users to correct the value before they move on, so I tried your second code set. Unfortunately, it wouldn't allow me to enter a new value after it cleared the cell, because the cell was empty, which triggered the message box. I changed the code as follows:

Please Login or Register  to view this content.

Now it ends the macro if the cell is empty too. Unfortunately, it also allows the user to leave the cell blank, which isn't exactly desireable either. There are further operations in the sheet that will require values for both cells, so the omission would be caught later, but it would be nice to catch it in the beginning too.

Another approach would be to wait until the user enters another control value via an input box. (I may have mixed up your high/low cells)

Please Login or Register  to view this content.

... it wouldn't allow me to enter a new value after it cleared the cell, because the cell was empty

Sorry, the Undo should appear after events are disabled.

Mike's solution looks good also.