How to setup and call " Excel VBA UserForm setup with few option buttons "

[ArbeitWali]

Hey Experts...

I'm trying to use a UserForm to enable choice options on which Tabs to print activated by Sub ALL_GCs().

The VBA "UserForm2" (attached) and the file is located here: (link):
I have 13 options or Checkbox on the UserForm....)

Thank You
or here: https://drive.google.com/file/d/0B_C9CGARkEdaQ2d0STlnR2ZDYkE/view?usp=sharing

 

[Hui]

Which ranges on each Division do you want to print?

 

[ArbeitWali]

Hi and thanks much in advance... So the ranges vary by tab and they are the ones already copied onto the "Print" tab that's usually hidden after printing or print to file..

So in a essence, the range to print is all that there is on the "print" tab...

Only tables with SubTotals greater than zero we want to print ..so they're identified and copied macro to that tab for printing.

Thank you

 

[Hui]

I can see the Print sheet
But there is no identification as to the various divisions

Can you please clarify what you want printed based on the Form2?

 

[ArbeitWali]

Hi and thanks again... So what I want printed based on the UserForm2 happens at the very beginning of the subroutine Sub ALL_GCs().

It's where the I'm prompted (via a User Form dialog box) to select a print option and where I select the (DIV) Divisions I want to print. So I need help with the code below to be ideally modified to work with UserForm2:

UserForm2.Show
If UserForm2.Cancel = "True" Then
    Unload UserForm2
    Exit Sub
End If
If UserForm2.OK = "True" Then
    If UserForm2.OptionButton2.Value = True Then
        Application.ActivePrinter = "Adobe PDF on Ne02:"
    Else: End If
End If
Unload UserForm1

For Each cbDiv In Controls
UserForm2.Show
    If TypeName(cbDiv) = "CheckBox" Then
        If CheckBox15.Value = True Then
            Call DIV_#       ' Process and Print that division
        End If
    End If
Unload UserForm2
Next