Drop down tables
Eliminate Pivot Table Annoyances
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Drop down tables

  1. #1


    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?


  2. #2
    New Member
    Join Date
    Mar 2002
    Post Thanks / Like
    0 Post(s)
    0 Thread(s)


    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.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts