Right now I have a UserForm with multiple pages on. The different multipages are used to input different kinds of data onto different sheets in the workbook.
When completed all data will be consolidated onto two sheets for printing.
On first page of multipage I have a frame with printing options.
1. I want the user to be able to chose what sheets to print, one or both.
2. After printpreview I also want the checkboxes to be cleared (not checked). I have tried to use the “.Valus = False” but it wont clear the box…
3. Can I set the button cmdPrintEvent to actually print the selected sheets without them being previewed? If so, can anybody hint about the code for that?
Private Sub cmdPrintEvent_Click() If cbSammanfattandeB = True And cbAlkoholP = True Then Me.Hide Sheets(Array("Mastersheet", "2BPrinted")).PrintPreview Me.Show ElseIf cbSammanfattandeB = True Then Me.Hide Sheets("2BPrinted").PrintPreview Me.Show ElseIf cbAlkoholP = True Then Me.Hide Sheets("Mastersheet").PrintPreview Me.Show cbAlkoholP.Value = False End If End Sub