allow one checkmark per group of boxes in excel

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

Guest

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?
 
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
 
Back
Top