Check Boxes Grouped
 

I have about 10 check boxes embedded on my sheet, is their a way to have them
linked so only one is checked at all times. When you check on a new box
within the group the other box becomes unchecked.

Check Boxes Grouped
 

Far, far easier would be to use the control that was designed to operate
that way... an Option Button (its icon is a small circle with a dot inside).

Rick


"Jase" wrote in message
...
I have about 10 check boxes embedded on my sheet, is their a way to have
them
linked so only one is checked at all times. When you check on a new box
within the group the other box becomes unchecked.

Check Boxes Grouped
 

Thanks

"Rick Rothstein (MVP - VB)" wrote:

Far, far easier would be to use the control that was designed to operate
that way... an Option Button (its icon is a small circle with a dot inside).

Rick


"Jase" wrote in message
...
I have about 10 check boxes embedded on my sheet, is their a way to have
them
linked so only one is checked at all times. When you check on a new box
within the group the other box becomes unchecked.