Pause macro once message box pops up

[Howardc1001]

I would like to amend my code to allow the macro to be paused once the message box appears and the necessary info has ben inputted. Once inputted , the macro to continue

It would be appreciated if someone could kindly advise me on how to do this

Please Login or Register  to view this content.

[BadlySpelledBuoy]

How you handle this will very much depend on what information needs adding, where and at what point it should be added.

Your VBA above only tells us you're copying data from one sheet to another and deleting duplicates. It doesn't explain enough about what the process is for us to assist in how to validate it all.

If there is info that needs adding then it would be usual practice to check if all required data exists and continue if it does rather than pause a macro while the user adds it. Or stop the macro above, prompt the user to add the data and then by one means or another run another macro when they've done their bit.

BSB

[Howardc1001]

Thanks for your reply and explanation.


once the message box appears, the user will have to manually check if he/she needs to input data after which the macro will then have to continue


Based on your input, it appears that the best solution, would be to run another macro after the user has inputted the data

[Winon]

Hello Howardc1001,

Another option would be to use a Userform in non Modal view as a "Message Box", do what is required, and continue with your Macro.

Regards

[Howardc1001]

Thanks for the advice