Can you pause a macro in excel to input data and continue?
 

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.

Can you pause a macro in excel to input data and continue?
 

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("Enter First Number:")
Range("g1").Value = k
l = InputBox("Enter second number:")
Range("g2") = l
End Sub

hth
Vaya con Dios,
Chuck, CABGx3



"Hutch" wrote:

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.