Message box before printing with a Yes and No.

Hi all

I am in requirement of a message box which pops up before printing. Message box contains questions like "Have you verified the Totals?", "Have you verified the total count in Annex III and 6p?" etc., If answer is yes, then go ahead printing, if it is no,then abort the printing.

I am attaching an image of what I intended.

Your help will be much appreciated.

Maybe:

Please Login or Register  to view this content.

*Edit* - code above is far better!

Hi Ravana, I think you simply need some message boxes, followed by if statements. This isn't eloquent but would work:

Please Login or Register  to view this content.

You can then do an if statement after each messagebox, so if they click No then exit sub, else continue:

Please Login or Register  to view this content.

repeat for each question.

or you could do a loop

Please Login or Register  to view this content.

Then at the end, all conditions have been met so you can go ahead with the print.
Sorry, not had time to write the code out but it should provide a start.

Please Login or Register  to view this content.

I used the code in ThisWorkbook sheet; even on saying no, it is still printing.

@JasperD...your code is ok with me.

However, JOHN H. DAVIS code looks more elegant; it looks like system is asking me questions; so, if there is any change required in that code, do help me.

@JasperD, after saying yes for every question, questions are repeating once again before printing.

@JasperD

This code I am using in Workbook module, however, I require the prompting only for few particular sheets (like sheet3, sheet4, sheet5) and not to all sheets;

Is there is a way?

I got it.

Any tanx to all.