software

I have a spreadsheet that I have to use two or more macros. I have to
change/input numbers in different cells at different places in the process. I
wondered if there was a way to set a pause at these points of input using one
macro with a pause and continue function.

Here's some sample code to show one way you can input two numbers in two
different cells..........modify to suit

Sub InputData()
Dim k, l 'As Long
k = InputBox(quot;Enter First Number:quot;)
Range(quot;g1quot;).Value = k
l = InputBox(quot;Enter second number:quot;)
Range(quot;g2quot;) = l
End Sub

hth
Vaya con Dios,
Chuck, CABGx3
quot;Hutchquot; wrote:

gt; I have a spreadsheet that I have to use two or more macros. I have to
gt; change/input numbers in different cells at different places in the process. I
gt; wondered if there was a way to set a pause at these points of input using one
gt; macro with a pause and continue function.