Macro Editting after Coming Upon needed User Input

[YeshyTiger]

Hello,

I'm trying to streamline a larger maco loop so that I do not have to re-run the macro each time I hit a needed user input. I'm not quite sure of the best way to go around this, so any "outside of the question" suggestions are welcome.

So here's the question: Is there a way to pause the macro, or allow background editting of workbook to be done before continuing on with the macro?
Or should I set up userforms?

Thank you

              For I = 62 To 1061
                        If Cells(I, 2).Value = nil Then
                        Application.ScreenUpdating = True
                        Response = MsgBox("Is There Deleted WBS in Tasks Section", vbExclamation + vbYesNoCancel)
                        Select Case Response
                            Case Is = vbYes
                                ActiveWorkbook.SaveAs Filename:="C:\Documents and Settings\jgeiger\Desktop\PMP Input Folder\" & ActiveWorkbook.Name, FileFormat:=xlNormal
                                Exit Sub
                            Case Is = vbNo
                                End If
                            Case Is = vbCancel
                                Exit Sub
                        End Select
                        End If
 
                    Next I

 

[venkat1926]

did you try the method "wait". see excel vba help under "wait:.

 

[YeshyTiger]

This is not a function of time, though. I would rather it continue upon clicking a button or pressing a key.