Click the "Insert" button on the Developer tab and then select "Form Controls" from the drop-down menu. Click "Combo Box" and then click the cell in which you want the box to appear.

You can use a menu command to create a hyperlink to a named range or you can use a simple drag-and-drop trick.