Pause macro, continue every time a press yes

[mergim]

Hello Guys,

I'm trying to do this code, where for every step of the macro, you have to choose whether to continue or not.
Right now, my code is looking up a value in a database, and there are around 50 values to look up. I want my code to run, so it pauses in between each and every value, and first be able to continue to the next value, as soon as I have pressed continue. It has ofc to continue from where it stopped/paused and not start all over again.
The reason I want it to pause in between look ups, is because I want to take notes in another excel doc. I have tried with a msgbox, but I cannot take notes if the msgbox is popped up.
Thanks guys!

Windows("111 - 1 storage Req Total.xlsx").Activate
    ActiveSheet.Range("$A$1:$N$33114").AutoFilter Field:=2, Criteria1:= _
        "Polymer 123456789"
'' pause
'continue
    Windows("111 - 1 storage Req Total.xlsx").Activate
    Range("B1").Select
    ActiveSheet.Range("$A$1:$N$33114").AutoFilter Field:=2, Criteria1:= _
        "Polymer 123456789"
' pause
'continue
   
    Windows("111 - 1 storage Req Total.xlsx").Activate
    ActiveSheet.Range("$A$1:$N$33114").AutoFilter Field:=2, Criteria1:= _
        "Polymer 123456789"
 'pause
 
'continue
 
    Windows("111 - 1 storage Req Total.xlsx").Activate
    ActiveSheet.Range("$A$1:$N$33114").AutoFilter Field:=2, Criteria1:= _
        "Polymer 123456789"

 

[JGordon11]

If you open up a separate session of excel you could use the MsgBox technique in session one to pause, and still work in another spreadsheet while paused in session 2.

Open Excel files in Separate Instances or Multiple Windows

Learn how to open multiple instances of Excel. Having a separate instance allows you to run an intensive task while you work in another window.

gorilla.bi

 

[mergim]

If you open up a separate session of excel you could use the MsgBox technique in session one to pause, and still work in another spreadsheet while paused in session 2.

Open Excel files in Separate Instances or Multiple Windows

Learn how to open multiple instances of Excel. Having a separate instance allows you to run an intensive task while you work in another window.

gorilla.bi

Hello,

That is what I have been trying to do, but it doesn't work unfortunately.
The msgbox forces me to either to press "yes" or "no" before I can go into another document.