If your checkboxes are from the Forms toolbar you can change all values in
one go like this

ActiveSheet.CheckBoxes.Value = xlOff ' xlOn

Your question is ambiguous though, not sure if something like the above is
what you want or if you want to change certain checkboxes.

Regards,
Peter T

"Matt" wrote in message
...
I have an excel sheet with many Yes/No, Good/Abnormal checkboxes. The list
is
long. I want to have this checksheet have a feature to select all Yes, or
Select all no, or select all good, select all abnormal, to avoid the
operator
having to check all if good/bad/ or the other. Any suggestions