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!
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!
VBA Code:
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"