It's done with Data validation, see

http://www.excel-it.com/data_validation.htm