View, Toolbars, Forms. Insert a Combobox.
Right click it, select Format Control.
Input Range is the range where your list is stored.
Linked cell is the cell where the chosen value will be written. This value is the index number of the selection. Thus if you had your list in A1:A3 and the linked cell is A5, the foillowing formula will give the linked value.