Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
userform delete sheet
I was provided with this as a way to tell my userform to print only th
selected checkboxes. Is there a way to also tell it to delete th unchecked checkboxes from the worksheet? 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 Nex -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
userform freezes sheet | Excel Discussion (Misc queries) | |||
UserForm and combo box to another sheet | Excel Discussion (Misc queries) | |||
userform delete sheet | Excel Programming | |||
Selecting sheet after Userform | Excel Programming | |||
Delete userform/module using VB | Excel Programming |