I began using checkboxes when I first started creating this workbook, only to
find out later that it was going to be a problem if the user selected more
then one checkbox. However, now I have well over 100 checkboxes on 1
worksheet that are linked to 100's of cells in other worksheets.

I got the checkboxes from the Forms Toolbar

"Rick Rothstein (MVP - VB)" wrote:

Why are you using CheckBoxes instead of OptionButtons? OptionButtons have
the functionality you want built-in whereas you will have to create code to
duplicate the functionality if you use CheckBoxes. Next question... where
did you get your CheckBoxes (or OptionButtons if you decide to go with my
suggestion) from... the Forms toolbar or the Visual Basic toolbar?

Rick


"tracktor" wrote in message
...
I have checkboxes on my worksheet that need to be grouped together. If
there
are 2 or more checkboxes I only want 1 of them to be checked, and the
other(s) to be unchecked.. In other words if 1 checkbox value is true, I
want
the others in the group to be false.