Make all check boxes = true

**azland00123** · 03-02-2012, 04:55 PM

I want to be able to click a button and scan the sheet and see if there are any check boxes and make them true so I can then decide what to print from there. I would then click another button to print the documents associated with these check boxes. And finally click a third button to clear all the check boxes. I have some code to clear all the check boxes but seem to be having a hard time getting the code to select all the check boxes.
The code I have is as follows:

Please Login or Register  to view this content.

Any help getting this code to make the check boxes = true would be greatly appreciated. Thanks

**tigeravatar** · 03-02-2012, 05:02 PM

azland00123,

Welcome to the forum! In the future, please wrap your code in code tags per the forum rules (link in my sig).
As to your query, wouldn't you just change the False to True?

**azland00123** · 03-02-2012, 05:28 PM

Thanks tigeravatar,
I fixed the post as per the rules sorry about that.
I thought that it would be that simple too, but it wont work and I dont know why. It selects the area in B2:B7 but it wont clear the content or make the check boxes True. There are no errors given when I run the code as True either.

**tigeravatar** · 03-02-2012, 06:07 PM

Weird. I created a dummy workbook and put in some activeX checkboxes and the code checked them all just fine when I changed the false to true. Not sure where the disconnect is.

Can you upload a sample file that is experiencing the problem?