Pop up on pressing print button

[MarkDShark]

Is there a way to create a pop up box once a print command button is pressed? Once the print button is pressed, a popup would appear asking if certain information on the sheet is correct (information from certain cells i select for it to pick up), with an ok and cancel button, and once the ok is pressed, the printing would continue or "cancel" to correct the info. Is this possible?

 

[rs2k]

This bit of code takes the data from Sheet1 A1:D1 and places it on the userform (popup)

Private Sub UserForm_Initialize()
Label2.Caption = Sheets("Sheet1").Range("A1").Value
Label3.Caption = Sheets("Sheet1").Range("B1").Value
Label4.Caption = Sheets("Sheet1").Range("C1").Value
Label5.Caption = Sheets("Sheet1").Range("D1").Value
End Sub

HTH
Colin

 

[rs2k]

The label doesn't have to reference a cell, you can also use it as its name sugests, a 'label' to type a comment in, 'Is the below correct?' then use the other labels to show the data entered.

 

[MarkDShark]

Will give it a try. Thanks for the info! Hopefully i get it right.

 

[MarkDShark]

I just noticed, i pasted in my clear button code, not the printing code. Oops!

 

[MarkDShark]

I got it to work, but the popup doesn't close once i've verfied the information as correct and allowed the printing. I named the 2 buttons yes and no, upon selecting as, the doc should print and the pop up should close, well it prints but the box remains open. Is there another piece of code that needs to be part of the print code? Code i'm using,

Private Sub CommandButton1_Click()
Sheets(2).PrintOut
End Sub

Thats the code for my "Yes" button. Once selected, it will print the sheet. It needs to close after Yes is selected.