AUTOMATICALLY CLEARING CHECKED BOXES

cdnqte

Board Regular
Joined
Jul 14, 2004
Messages
132
I have a spreadsheet that is designed to randomly assign groups of 4. In this sheet there are a group of 35 check boxes of which can have 24 checked at any given time. I would like to clear these boxes and set the linked cells to FALSE each time the sheet is open. Is there a way to record a macro that will clear the check boxes upon request?
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

Chas17

Well-known Member
Joined
Oct 16, 2002
Messages
657
assumptions:
1. you are using check box from Forms toolbar
2 linked cells for check boxes are in E1:E35

Place a button on worksheet, place this code in module for button
Code:
Sub Button4_Click()
Dim i As Integer

For i = 1 To 35
    Cells(i, 5) = False
Next i

End Sub

You could also place code in worksheet open event.
Chas
 

cdnqte

Board Regular
Joined
Jul 14, 2004
Messages
132
Wonderful! One more question (I am an amature at this..)

In that code, how do I determine which sheet? The "Clear All" button is on the main page but the data is actually on a separate sheet.

Thanks so much for your help!
 

cdnqte

Board Regular
Joined
Jul 14, 2004
Messages
132
Actually, I just answered my own question...

Thanks again for your help..
 

Forum statistics

Threads
1,136,268
Messages
5,674,734
Members
419,523
Latest member
Urnovio

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top