rvanbrandenburg
New Member
- Joined
- Sep 28, 2006
- Messages
- 1
I'm trying to make a printform where you can select different ranges.
For example:
I activate the dialog where you can make a selection of diferent area's (selectionbox). Then:
Sub printmacro()
DialogSheets("dialog1").Show 'shows dialogbox
End Sub
Sub printselection()
If DialogSheets("dialoog1").CheckBoxes(1).Value = 1 Then 'if this area is selected then print this after OK
Range("printarea1").printout
End If
If DialogSheets("dialoog1").CheckBoxes(2).Value = 1 Then
Range("printarea2").printout
End If
If DialogSheets("dialoog1").CheckBoxes(3).Value = 1 Then
Range("printarea3").printout
End If
If DialogSheets("dialoog1").CheckBoxes(4).Value = 1 Then
Range("printarea4").printout
End If
End Sub
Somehow if i click okay it doesn't work. Can somebody help me??
For example:
I activate the dialog where you can make a selection of diferent area's (selectionbox). Then:
Sub printmacro()
DialogSheets("dialog1").Show 'shows dialogbox
End Sub
Sub printselection()
If DialogSheets("dialoog1").CheckBoxes(1).Value = 1 Then 'if this area is selected then print this after OK
Range("printarea1").printout
End If
If DialogSheets("dialoog1").CheckBoxes(2).Value = 1 Then
Range("printarea2").printout
End If
If DialogSheets("dialoog1").CheckBoxes(3).Value = 1 Then
Range("printarea3").printout
End If
If DialogSheets("dialoog1").CheckBoxes(4).Value = 1 Then
Range("printarea4").printout
End If
End Sub
Somehow if i click okay it doesn't work. Can somebody help me??