Clear all checkboxes

[bjohnsonac]

Hi,

I have a workbook with form checkboxes on about 3 of the worksheets. I have two issues I need help solving.

1. For certain groups of checkboxes, If the "YES" checkbox is checked, I need the "No" to be cleared and vice versa.

2. I need code that will automatically clear ALL the checkboxes in the workbook for when the user is ready to create a new file.

I have searched several forums, and tried several different code options, but keep getting a run-time error saying "Unable to set the Value Property of the CheckBox Class"

Been pulling my hair out for about an horu now so any help would be appreciated!

[Leith Ross]

Hello bjohnsonac,

This will clear all the Forms style check boxes on all the sheets.

Please Login or Register  to view this content.

[bjohnsonac]

That is the exact same code I have been using and I get the run-time error

I am attaching a sample of the workbook here for reference if anyone can figure out my problem.

Thanks again!

[Leith Ross]

Hello bjohnsonac,

Now that was a learning experience! It turns outs that grouped Forms Controls must first be selected before the control's value can be changed. The macro below works. It clears grouped Forms Check Boxes and Control ToolBox CheckBoxes. This has been added to the attached workbook.

Please Login or Register  to view this content.

[2funny4words]

posted in the wrong spot