Excel 2007 : drop down box

[tiffanyt]

Hi, I know this function was available in the 2003 version however I can not locate it in the new version of Excel. I'm looking for a drop down box but I want to be able to type the first few letters of the word to go to that field. I have a drop down box with over 1200 locations (destinations) however I didn't want to have to scroll thru the whole list? Please help.

[royUK]

A ComboBox from the Controls ToolBox or on a UserForm will do this.