Drop down tables

[Guest]

I need to create a worksheet where
1) There is a question with a drop box where you select the answer
2) Can't do validation,etc because the list must not be seen on the worksheet.Could hide it but then I would need to protect the worksheet
3) Can I then add an if operation based on the selection made on the drop box to award numerical points to answers?

HELP

 

[tk19]

On the control toolbar click on combo box. Draw a rectangle on the spreadsheet with your mouse. Right click on the box and click properties. Fill in the ListFillRange and LinkedCell properties.
The linked cell contains what you select in the combo box. You could have a formula elsewhere that will determine points scored. This and the listfillrange can be on another sheet, which you can hide (and password protect by going into the VB editor, changing the sheet's property to Very Hidden, then assigning a password to the project). You can then have a cell on the first sheet which echoes the score determined on the hidden sheet. You can then password protect the cell, and voila, you're done.