Hi,
The powers that be want to add a print box to a report. They want two drop down boxes/combi boxes on the front worksheet. User selects the time period that they want to print in Box 1 (e.g April - June, July-Sept) and in Box 2, the level of report that they want eg. Whole report; Team Report.
Box 1 contains 6 conditions (possible dates), Box 2 has 3 conditions (level of report) and depending on those selected, different worksheets will be printed.

I can write the code to print from one box, but how do I combine the two boxes??

i.e User selects 'April to June' AND 'Team level report' then pages A, B and C print.
User selects 'April to June' AND 'Management report' then pages A,D and E print

Thanks a lot for any help! I appreciate it.