Message Box Suggestion

[jstevens]

I have code that applies an advanced filter from the Source sheet to the Target sheet. The code works just fine as the user is looking at the Target sheet for results.

I would like to induce into the code a message box that would allow the user to temporarily suspend the code and allow the user to change sheets from the Target to the Source sheet. This will give the user an opportunity to see additional data in the Source that is not filtered to the Target sheet. Going back to the Target sheet the message box would prompt for the next filtered record or cancel the operation.

Your suggestions are appreciated.

[Rudi]

Hi John,

It's only my opinion, this method would be a bit disruptive.

How about a process where the user can determine the criteria in a table and run the macro to see the result. If they need changes, they can view the source, determine what they want in addition, update the criteria table and run the macro again. The code will extract records and place it in the target sheet based on the users criteria definition. For a working model, see the attached workbook...

Extract Data.xlsm

[jstevens]

Rudi,

Food for thought...I opted for a form and listbox selection.

Thanks!

[Rudi]