Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
allow one checkmark per group of boxes in excel
I have set up a form in excel using 3 boxes for yes, no, n/a can they be set
up to allow only one box per row to be checked? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
allow one checkmark per group of boxes in excel
This is why optionbuttons exist.
If you use optionbuttons from the Forms toolbar, you can surround each group with a groupbox. If you use optionbuttons from the Control toolbox toolbar, you can change the groupname of each optionbutton in that group to have the same groupname (under properties). You may want to look at a sample from Debra Dalgleish's site: http://www.contextures.com/xlform01.html mamt wrote: I have set up a form in excel using 3 boxes for yes, no, n/a can they be set up to allow only one box per row to be checked? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel Drop Down Boxes | Excel Discussion (Misc queries) | |||
Can't print a group of spreadsheets Excel 2003 | Excel Discussion (Misc queries) | |||
Excel sort option disabled--file name followed by "group" at top . | Excel Discussion (Misc queries) | |||
Can't group pivot table items by month in Excel | Excel Discussion (Misc queries) |