Pausing a Macro During Execution

Hi,

I have a macro that runs when the user selects an item from a drop down menu.I need to pause until the user fills in information - min and max values - in two cells. I would like the macro to detect when the user has filled in both cells and then resume the execution of the macro. Can anyone please tell me how to do this? Thank you.

Also I would like to create a drop down menu on the fly in a specific cell via the macro. Is this possible? If yes, can you please suggest how? Thank you.

Here's an example of how I do it. We start at the end of my current macro, go to Pauser, create two buttons to activate two other macros (choice for the user). After they choose, KillButts kills the buttons, then off to the next macro ("Resumer1"):

Please Login or Register  to view this content.

Thank you Joimili. This is very interesting but overkill for my application at this time. I will however file it away for future reference. Once again, thank you..

Thank you shg. This will do exactly what I need for my application. I did not even know this existed. Thank you.