Hardcode options into list

[[email protected]]

For my school project, I must create a spreadsheet with lists. I am not allowed to have the data from the lists displayed anywhere on the sheet except for the results which will be hidden by the list (Combo box) in question. I have 3 such combo boxes and I need the options inside them to be hard coded into the spreadsheet. How do I do this?

[mrchoppychops]

you need to be more specific.

do you mean that you arent allowed to put the data on the sheet or that it cant be displayed. for example you could very easily format a cell so that it shows nothing, or you could change the font colour or hide the column...

[[email protected]]

The data is not allowed to be on the sheet, in another sheet or anywhere but hardcoded into the list.

[mrchoppychops]

Please see this thread

http://www.excelforum.com/excel-prog...x-options.html

[[email protected]]

Thank-you, I've been looking for this for aeons.