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.