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:
www.contextures.com/xlform01.html
mamt wrote:
gt;
gt; I have set up a form in excel using 3 boxes for yes, no, n/a can they be set
gt; up to allow only one box per row to be checked?
--
Dave Peterson
- Aug 28 Tue 2007 20:39
allow one checkmark per group of boxes in excel
close
全站熱搜
留言列表
發表留言