Need macro that clears option buttons made with the control toolbox

[79rotorhead]

I created some excel 2003 spreadsheets to use for Fire/Police dispatchers. I have a series of yes/no option buttons that were created using the control toolbox. I have a macro that clears all the blanks where text is added, but want to add a line that clears the option buttons also.

[Andy Pope]

Set the linked cells to FALSE

[79rotorhead]

Thanks Andy. I think I am on the right track, but want to write it once for all the 30+ worksheets. How do I modify the following code or do I need to retype for each sheet?

Please Login or Register  to view this content.

[Andy Pope]

Please Login or Register  to view this content.

[79rotorhead]

Not sure what I am doing wrong, but your code runs without any errors, but the radio buttons won't clear. Thanks for trying. If it matters, I am not using a form.

[Andy Pope]

post example workbook

[79rotorhead]

Sorry it took so long to get back to you.
Here are two macros that I have for each of the 30+ worksheets that I am using. One saves the info to the hard drive and one clears the typed data. Would like to add one that will clears radio buttons. I still have to input the radio buttons onto the worksheet. Am using check boxes for now.

Please Login or Register  to view this content.

[Andy Pope]

assuming the ranges are the cells linked to the controls

Please Login or Register  to view this content.

[79rotorhead]

I have the radio buttons as "option buttons". They are the same number on each worksheet (OptionButton1, etc). They are not linked to a specific ranges. When I put in your recommendation, it confused the program because two macros had the same name. So I changed yours to Clear_Fire_Buttons, but it said there was an invalid or unqualified reference. How can you just set values of all OptionButtons on a worksheet to False? Wouldn't that clear them?

[Andy Pope]

I missed the sheet reference

Please Login or Register  to view this content.

But any way that code will not do anything to the controls if they are not linked to those cells.

Post a small example file.

[79rotorhead]

Rules won't allow me to attach a file.

[Fotis1991]

Rules won't allow me to attach a file.

What do you mean by that? Rules by whom?

[79rotorhead]

OK. Since I didn't understand the attachment loading procedures, I assumed it was not allowed. Sorry. Excel program attached. Thanks.

[Andy Pope]

try this

Please Login or Register  to view this content.

[79rotorhead]

Thanks Andy. It works great. You're amazing. Now to try to understand what you wrote.

[79rotorhead]

Andy, the government switched from excel 2003 to 2010. Now the program doesn't work. the buttons no longer function and the clear function no longer works results in an error statement.

[Andy Pope]

In what what way does it not work? What are the details of the error
Can you post latest workbook