Check Boxes or Option Buttons

[Lynda]

I have been assigned a task at work to create a spreadsheet, similar to a
survey I guess, where I will have a list of categories in the left column and
beside each category I will have 5 check boxes to gauge the strength of the
response from, say, critical down to not important. I don’t want them to be
able to check more than one box at a time per category. I have checked out
the treads on grouping but get a little confused about how to go about it. I
would then like to be able to sort the results by importance. I am using
Excel 2003 and I do not have InfoPath at work or at home.

 

[Ron Coderre]

This link has Dave Peterson's instructions and
code to let Excel build the form for you:
http://www.contextures.com/xlform01.html

Is that something you can work with?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

 

[Dave Peterson]

If you don't want more than one option checked, it would more usual to use
OptionButtons instead of Checkboxes.

You may want to look at this from Debra Dalgleish's site:
http://contextures.com/xlForm01.html

 

[Lynda]

Thank you Ron and Dave, this will definitely solve my problem.
I really appreciate your help. Cheers