View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default 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