Creating a User controlled pause in VBA

[Poundland]

Guys,

I have an issue.


I have written some code which formats a series of reports into one master report and then sends an email informing end users of its collation.

Now my issue is that once the formatting is complete I want the macro user to be able to view the report for any anomolies in the data prior to sending the emails.

How can i using VBA programme in a Pause in the VBA code that when the user is ready they can press a key and complete the VBA run?

[mikerickson]

MsgBox "Shall I continue"

or use and InputBox's top,left argument to put it out of the way

[Bob Phillips]

What are you going to do if it isn't okay, send it anyway? If you abort the run, how does it get sent later?