allow one checkmark per group of boxes in excel

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?
 
D

Dave Peterson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Checkmark question. 3
How do I change a check box checkmark to an X 1
check box - allow only one check mark per category 1
how to delete drop down boxes 2
30 fields each to be checked by 1000 people 2
Create a form in Excel 1
Checkmark box in Excel 3
Aligning check boxes in Excel 2007 5

Top