Preventing multiple check boxes from being checked
 

I have a worksheet with over 20 rows of check boxes with 5 check boxes in
each row. (from the forms toolbox) I would like to prevent the user from
checking more than one box in each row. Is this possible?

BTW, this forum has been a great help. I'm so glad that expert Excel users
are so willing to share their wealth of knowledge.

Thanks again.

Jae

Put them in a group box, again from the forms toolbar.

Drag the group box onto the sheet, then drag the checkboxes in.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jae" wrote in message
...
I have a worksheet with over 20 rows of check boxes with 5 check boxes in
each row. (from the forms toolbox) I would like to prevent the user from
checking more than one box in each row. Is this possible?

BTW, this forum has been a great help. I'm so glad that expert Excel
users
are so willing to share their wealth of knowledge.

Thanks again.

Jae

Hi!

If you were to use option buttons instead of checkboxes that would prevent
more than a single selection. If you have a series of 5 option buttons only
one can be selected.

It would be a lot of work replacing 100 checkboxes with option buttons,
though!

Biff

"Jae" wrote in message
...
I have a worksheet with over 20 rows of check boxes with 5 check boxes in
each row. (from the forms toolbox) I would like to prevent the user from
checking more than one box in each row. Is this possible?

BTW, this forum has been a great help. I'm so glad that expert Excel
users
are so willing to share their wealth of knowledge.

Thanks again.

Jae

Ignore that, I read optionbuttons for checkboxes. See Biff's response.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Bob Phillips" wrote in message
...
Put them in a group box, again from the forms toolbar.

Drag the group box onto the sheet, then drag the checkboxes in.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jae" wrote in message
...
I have a worksheet with over 20 rows of check boxes with 5 check boxes
in
each row. (from the forms toolbox) I would like to prevent the user
from
checking more than one box in each row. Is this possible?

BTW, this forum has been a great help. I'm so glad that expert Excel
users
are so willing to share their wealth of knowledge.

Thanks again.

Jae