Pausing a Macro

[ercedwards]

I have a macro that scans a list of orders to find those belonging to a certain customer.

When it finds one it displays the order and then finds the next one.

What I need to macro to do is let me edit that order (i.e. edit what's on the screen) before carrying on to find the next one.

Is there a way to do that?

Thanks

 

[FracinDean]

Set a range name in your workbook called "lastOrderFound". This cell will contain a cell address.

Use the value of "lastOrderFound" as the starting point for the search.

Whenever the macro finds an order belonging to the customer, just update the value of lastOrderFound and stop the macro. When you restart, it will find the next one.

You may want your macro to re-set the value of lastOrderFound to the beginning of the search range after you reach the end.

 

[DataBlake]

I have a macro that scans a list of orders to find those belonging to a certain customer.

When it finds one it displays the order and then finds the next one.

What I need to macro to do is let me edit that order (i.e. edit what's on the screen) before carrying on to find the next one.

Is there a way to do that?

Thanks

You're going to want to create a userform named "fstop"
On the userform put a label with the caption "Press continue after edit" or whatever you want
Also add a command button with the caption "continue"

after you've done this copy this into the userform code

Private Sub CommandButton1_Click()
Unload fstop
End Sub

then copy the following code into a module

Sub YourCode()



FIRST PART OF YOUR MACRO
 
Call Pauser
    
SECOND PART OF YOUR MACRO
 
End Sub

Sub Pauser()
Application.ScreenUpdating = True
fstop.Show
Do Until fstop.Visible = False
DoEvents
Loop
Application.ScreenUpdating = False
End Sub

Basically where you want the macro to pause is where you will split it in half with "Call Pauser" in the middle
That should do it.

*important* make sure the userform's "ShowModal" is set to false so that you can edit while the userform is up