Pause or stop VBA for a manual edit to the sheet

[Javi]

Hi All,

I have a sheet with approximately 75K rows. My code is adding columns, formulas and formatting working great. I would like to stop the code in the middle/at specific points with a message box to allow me to do a manual edit on the sheet. For instance, have a message box pop up with the message of what edit to perform (This will be predetermined not any type of calculation) and a continue button that will allow the code to continue after I finished my manual edit.

I seem to recall we can have the sheet active behind the message box so the message box would still be there as I am performing the manual edit. Once the manual edit is completed I could click continue and the code will continue or start/call a second macro.


Thank you, any advice or input would be appreciated.

 

[JLGWhiz]

Thank you everyone for all of the input and discussion on this topic. I use the Userform method. I separated my original code into several codes where I wanted the code to stop/pause. In the properties of the Userform I set “Show modal = False “ allowing me to edit the sheet with the Userform still open. The continue button on the Userform simply called the rest of the code.

FYI - the reason why I needed to stop/pause the code was my sheet ended up with 200K rows and I needed to delete out approximately hundred 190K based on a cell value. For some reason the code took too long to validate each row and delete, so I did it manually. The code took 20 minutes to delete the lines and manually it took about two minutes.

Below are the 2 delete row codes I tried.





Thanks again.

This would probably have solved the problem.

Sub t()
    With ActiveSheet.UsedRange
        .AutoFilter 13, ">1"
        .SpecialCells(xlCellTypeVisible).EntireRow.Delete
    End With
    ActiveSheet.AutoFilterMode = False
End Sub