Re: How do I create a macro to clear checkboxes?

[Mauro Gamberini]

CheckBox1.Value = False

 

[Guest]

Do I do this for each one of the checkboxes? where do I input it? thanks for
your help

 

[icestationzbra]

this piece of code will uncheck all the checkboxes on a sheet. you ca
assign this macro to a button.

Sub UnCheckBox()

With Sheet1

.CheckBoxes.Value = False

End With

End Sub

right-click on the sheet tab where it usually says 'Sheet1', selec
View Code from the context menu. paste this code there, and assign thi
macro to a form button.

if you need to uncheck only certain checkboxes, then revert with
little bit of detail as to how to figure out which checkboxes t
uncheck (are they associated with certain cells that are going to b
empty, etc...). if i am not able to help, someone else surely woul
be..