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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

hth
Vaya con Dios,
Chuck, CABGx3
 
Back
Top