Drop down tables

Mar 13th, 2002, 01:01 PM

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 · Mar 13th, 2002, 01:51 PM

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 13th, 2002, 01:01 PM	#1
Guest Posts: n/a	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

Mar 13th, 2002, 01:51 PM	#2
tk19 New Member Join Date: Mar 2002 Posts: 33	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.