Hi
I have created an order form which my sales team use to print out internal production orders. The workbook comprises of an input sheet which the sales team fill in, and an order printout which is on a seperate sheet. My issue is that the sales team may miss one of the boxes on the form and print the sheet out not knowing they have missed it. I would like the option of an error message when the "print" button is pressed to instruct the saleperson that they have missed an essential box, for example, "delivery date".
This is my code at present:
Private Sub CommandButton2_Click()
Sheets("Order").Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Sheets("Input Sheet").Select
Range("C5").Select
End Sub
Can anyone help?
Apologies if this is fairly simple, I'm fairly new to VB.
Thanks
Rowan
I have created an order form which my sales team use to print out internal production orders. The workbook comprises of an input sheet which the sales team fill in, and an order printout which is on a seperate sheet. My issue is that the sales team may miss one of the boxes on the form and print the sheet out not knowing they have missed it. I would like the option of an error message when the "print" button is pressed to instruct the saleperson that they have missed an essential box, for example, "delivery date".
This is my code at present:
Private Sub CommandButton2_Click()
Sheets("Order").Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Sheets("Input Sheet").Select
Range("C5").Select
End Sub
Can anyone help?
Apologies if this is fairly simple, I'm fairly new to VB.
Thanks
Rowan