Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Check boxes - when one box is checked, I want a 2nd box to auto ch | Excel Discussion (Misc queries) | |||
How do I restrict only 1 of 2 check boxes be checked? | Excel Discussion (Misc queries) | |||
count check boxes | Excel Worksheet Functions | |||
Adding Check Boxes | Excel Discussion (Misc queries) | |||
how to incert multiple check boxes in excel | Excel Worksheet Functions |