Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check Boxes
In Excel 2oo7, is there a makro that uncheck all check boxes in a worksheet?
(empty them?) -- Felix |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check Boxes
'If they're from the forms toolbar:
ActiveSheet.CheckBoxes.Value = False 'If they're from the control toolbox toolbar: Dim myCBX As OLEObject For Each myCBX In ActiveSheet.OLEObjects If TypeOf myCBX.Object Is MSForms.CheckBox Then myCBX.Object.Value = False End If Next myCBX Felix wrote: In Excel 2oo7, is there a makro that uncheck all check boxes in a worksheet? (empty them?) -- Felix -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Check Boxes | Excel Discussion (Misc queries) | |||
Check Boxes | Excel Discussion (Misc queries) | |||
How do I increase the size of check in check boxes | Excel Discussion (Misc queries) | |||
Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) | |||
How do i create a value for check boxes or option boxes | Excel Discussion (Misc queries) |