I have a print button on sheet 1 that when clicked performs the operation below. I also have 2 option buttons in a group (Yes/No) that returns a value of either 1 or 2 in D26. I would like to be able to click the print button on sheet and if the option 1 (Yes) which returns value of 1 to D26 is selected then print 3 copies of sheet 2 if no is selected then just stick with the operation below. Thanks

Private Sub butPrint_Click()

Sheets("Sheet2").Select
Sheets("Sheet2").Range("I2").Value = _
Sheets("Sheet2").Range("I2").Value + 1

ActiveWindow.SelectedSheets.PrintOut Copies:=2, Collate:=True, _
IgnorePrintAreas:=False

Sheets("Sheet1").Select
End Sub