Allow Data Input while running looping macros

[redmoney]

I have a scenario where I have a macro that is calling another macro based on
whether a certain counter hasn't been reached. The macro that it is calling
is working as I have put in counter and other items to show me where the
macros as getting to. The macro is completing. However, there is a spot
within the called macro where I need to provide some user input but since
there is a zero defaulted to that field the macro isn't stopping to allow me
to add input information. Is there a way to stop the called macro to allow
data entry and then have it proceed on?

 

[Steve Schapel]

Redmoney,

Hmmm, I don't think you have given us enough to go on, to give a
definitive answer.

But you might like to look at the InputBox function - it could be that
this will be applicable to you harvesting the user input you need.