Preventing multiple check boxes from being checked

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
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
 
Ignore that, I read optionbuttons for checkboxes. See Biff's response.

--

HTH

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Check-box relative reference 1
Check Boxes 1
Check Box & Filter or not 2
How to Hide and Unhide Rows 2
Check boxes, Is this possible? 2
check box help 2
link check boxes in multiple cells 1
How to copy data from certain cell in one tab to another tab 1

Back
Top