Thanks again Ron! Great help! Sorry to keep on, but when I add the print preview code after say the first check box...it works, previews, but the userform stay on top and does not let me get out of it. Is there a way to close the userform after confirming selection? Thanks again in advance

----- Ron de Bruin wrote: ----

Hi Jordo

Add three checkboxes on your userform and one button
Try this code for the butto

Private Sub CommandButton1_Click(
Dim Num As Intege
Num = Abs(CheckBox1.Value) * 1 +
Abs(CheckBox2.Value) * 3 +
Abs(CheckBox3.Value) *

Select Case Nu
Case
MsgBox "Run the code for checkbox 1
Case
MsgBox "Run the code for checkbox 2
Case
MsgBox "Run the code for checkbox 3
Case
MsgBox "Run the code for checkbox 1 + 2
Case
MsgBox "Run the code for checkbox 1 + 2 + 3
Case
MsgBox "Run the code for checkbox 1 + 3
Case
MsgBox "Run the code for checkbox 2 + 3
End Selec
End Su


--
Regards Ron de Brui
http://www.rondebruin.n


"Jordon" wrote in message ..
Thanks Ron! One more curve....How can I add check boxes and allow user to select more than one check box which in turn preview
multiple print areas? In other words the user checks box 1 and box 2...hits the "OK" button and it previews both of those prin
areas
Thanks in advanc