userform CheckBox print
 

In my userform, I have print options that I need help with. I have
Print Button in my userform. I want to be able to click the prin
button, and print only the pages that are associated the the checkboxe
that are checked.

ie.
CheckBox1 is unchecked - do not print
CheckBox2 is checked - Print when print command button is selected.

etc...9 buttons total.

Any help provided is greatly appreciated

--
Message posted from http://www.ExcelForum.com

userform CheckBox print
 

Dim ctrl as Control
Dim chkbx as MSForms.Checkbox
for each ctrl in Me.Controls
if typeof ctrl is MSForms.Checkbox then
set chkbx = ctrl
if chkbx then
worksheets(chkbx.caption).Printout
end if
end if
Next

--
Regards,
Tom Ogilvy


"dok112 " wrote in message
...
In my userform, I have print options that I need help with. I have a
Print Button in my userform. I want to be able to click the print
button, and print only the pages that are associated the the checkboxes
that are checked.

ie.
CheckBox1 is unchecked - do not print
CheckBox2 is checked - Print when print command button is selected.

etc...9 buttons total.

Any help provided is greatly appreciated.


---
Message posted from http://www.ExcelForum.com/