How do I restrict only 1 of 2 check boxes be checked?

B

Board

I have 2 check boxes in an excel worksheet, and I would like to restrict it
so only one can be check at a time. So, if 1 on them is checked, and you try
to check the other one, a warning will pop up to stop you.
 
P

Peo Sjoblom

You could use code to restrict this, however what you should use are the
option buttons, they were made for this


Regards,

Peo Sjoblom
 
J

Jason

By code, do you mean I would have to write the code. Is there any type of
validation I could use?
 
P

Peo Sjoblom

Yes, yoiu have write the code or have someone write it for you, not by using
data>validation


Regards,

Peo Sjoblom
 
Top