Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Clear certain checkboxes
Is there a way to identify and clear only a certain subset of checkboxes on a
worksheet? I've got the ActiveSheet.checkboxes.value = xlOff, but of course, that clears all checkboxes. So...just wanting to know. Thank you for your time. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Clear certain checkboxes
If you know the names of the checkboxes, you could loop through all of them
looking for a match by name. If you know the location/range of the checkboxes to be cleared, you could loop through all of them and compare the .topleftcell of that checkbox with the range. How do you know which ones to clear? Arlen wrote: Is there a way to identify and clear only a certain subset of checkboxes on a worksheet? I've got the ActiveSheet.checkboxes.value = xlOff, but of course, that clears all checkboxes. So...just wanting to know. Thank you for your time. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Clear certain checkboxes
Dave,
Can I name just these 5 specific checkboxes through the Format Control menu? If I can, then what does the macro look like which identifies the names of those 5... "Dave Peterson" wrote: If you know the names of the checkboxes, you could loop through all of them looking for a match by name. If you know the location/range of the checkboxes to be cleared, you could loop through all of them and compare the .topleftcell of that checkbox with the range. How do you know which ones to clear? Arlen wrote: Is there a way to identify and clear only a certain subset of checkboxes on a worksheet? I've got the ActiveSheet.checkboxes.value = xlOff, but of course, that clears all checkboxes. So...just wanting to know. Thank you for your time. -- Dave Peterson . |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Clear certain checkboxes
Select the textbox you want to name. (I just rightclick on it.)
Type the new name in the namebox -- to the left of the formulabar. Type the new name and hit enter. Then you could use: activesheet.checkboxes("myCheckbox99").value = xloff activesheet.checkboxes("CBX_SendEmail").value = xloff activesheet.checkboxes("CBX_Whateveryouwant").valu e = xloff (Remember that these are the checkboxes from the Forms toolbar -- not checkboxes from the control toolbox toolbar -- but that matches your original code.) Arlen wrote: Dave, Can I name just these 5 specific checkboxes through the Format Control menu? If I can, then what does the macro look like which identifies the names of those 5... "Dave Peterson" wrote: If you know the names of the checkboxes, you could loop through all of them looking for a match by name. If you know the location/range of the checkboxes to be cleared, you could loop through all of them and compare the .topleftcell of that checkbox with the range. How do you know which ones to clear? Arlen wrote: Is there a way to identify and clear only a certain subset of checkboxes on a worksheet? I've got the ActiveSheet.checkboxes.value = xlOff, but of course, that clears all checkboxes. So...just wanting to know. Thank you for your time. -- Dave Peterson . -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Clear certain checkboxes
If you are using checkboxes from the Forms control bar, use
Dim N As Long Dim V As Variant V = Array("CheckBox1", "CheckBox3") For N = LBound(V) To UBound(V) ActiveSheet.CheckBoxes(V(N)).Value = False Next N List in the Array those checkboxes you want to clear. If you are using checkboxes from the Controls (ActiveX) control bar, use Dim N As Long Dim V As Variant Dim WS As Worksheet V = Array("cbx1", "cbx3") For N = LBound(V) To UBound(V) ActiveSheet.OLEObjects(V(N)).Object.Value = False Next N Cordially, Chip Pearson Microsoft Most Valuable Professional, Excel, 1998 - 2010 Pearson Software Consulting, LLC www.cpearson.com On Thu, 20 May 2010 08:59:01 -0700, Arlen wrote: Is there a way to identify and clear only a certain subset of checkboxes on a worksheet? I've got the ActiveSheet.checkboxes.value = xlOff, but of course, that clears all checkboxes. So...just wanting to know. Thank you for your time. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to clear all checkboxes on a form? | Excel Worksheet Functions | |||
Macro to clear checkboxes | Excel Worksheet Functions | |||
Macro to clear checkboxes and protected cells | Excel Worksheet Functions | |||
Clear Checkboxes | Excel Discussion (Misc queries) | |||
Macro to make all checkboxes false and clear all comboxes | Excel Discussion (Misc queries) |