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 dont 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.

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)


"Lynda" wrote in message
...
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.

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 wrote:

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 dont 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.

--

Dave Peterson

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