I need a message box to open up and display a message before printing.

[Bobp84]

I have some code here that I need modified, currently it prints the work sheet and clears the specified cells of the data in them and saves. I would like it to display a message box that states, "Have You Included a Contact in The Contact Field?" before the work sheet prints or clears the data. The message box would have YES and NO on it, once you click yes the spreadsheet will proceed to print, if you click NO then it will not print (or clear the data) and the cursor will go to cell I11 where the data needs to be entered. Is this possible? Any help at all would be appreciated.

Please Login or Register  to view this content.

[amotto11]

try this

Please Login or Register  to view this content.

[vandan_tanna]

Please Login or Register  to view this content.

[Bobp84]

It is popping up the message box with the Yes and NO options, but it still prints when I select NO. Any advice?

[vandan_tanna]

Try my code in post #3 or

change
if box = No then
to
if box = vbNo then

in post #2

[amotto11]

try mine and instead of no put vbno in the if statement

[Bobp84]

Got it, thanks you guys rock.