Call back or go back to macro after a user action such as clicking in a cell

[finaljustice]

I am about to write a small macro to do a iteration calculation. I would like though for the user to select me a cell so that the macro uses the value in that cell to start calculations. Now, what I think would be the problem is how do I code a "time" or notice an action such as clicking in a cell to continue with the macro.

Would it be by inserting a pause in the code of a certain time so that gives the user time to click and wait for the code to start? If so, how would much time is enough? Is there another thing that could restart the code such as "noticing a click in a cell" command in VBA?

Thanks for your attention, just thinking about what would be the best approach for this.

FJ

 

[AlphaFrog]

This may help...
Pausing a Macro to Get a User-Selected Range

Or do a web search for somthing like Excel VBA prompt to select a cell and you will find several other examples.