Inserting tick/untick boxes in excel 2003

[Guest]

Greetings,

Sorry if this is a stupid question. I have a spreadsheet and i want to enter
3 rows of boxes that i can simply click on to tick or untick them. Its for a
questionnaire so answers will vary from one person to another so i would just
like to click on the boxes to enter the tick for either a yes, no, or not
applicable answer.

I hope this makes sense, i already have the spreadsheet i want with this
tick/untick facility but its locked so i cant amend it to meet my needs (
hope someone can help otherwise im gonna have to start drinking this
lunchtime!!!

If someone could lay out a simple step by step process i would be most
grateful!

 

[Guest]

First of all, you would not use checkboxes as they permit yes, no AND not
applicable from being selected.

Use a radio button group instead, here the user can only select yes, no OR
not applicable.

Next, use VBA to arrange the data in an output format that you need...