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

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.

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


Regards,

Peo Sjoblom


"Board" wrote:

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.

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

"Peo Sjoblom" wrote:

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


Regards,

Peo Sjoblom


"Board" wrote:

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.

Yes, yoiu have write the code or have someone write it for you, not by using
datavalidation


Regards,

Peo Sjoblom

"Jason" wrote:

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

"Peo Sjoblom" wrote:

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


Regards,

Peo Sjoblom


"Board" wrote:

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.