Check out the InputBox function in Help. If you want a loop, you use a Do/Loop
construction. That's also explained in Help. There should also be examples.

On Thu, 4 Nov 2004 00:33:21 -0600, Chuckles123
wrote:


Looking for guidance on constructing code to pause macro and have user
input a 2- or 3-digit number, and then macro continuing. Also, it
would be useful for macro, after results are displayed in spreadsheet,
to loop back to input option.
Thanks in advance.
Chuckles123