Drop down box

QuestionEdit

I use a template with two drop down boxes with a lot of choices in each box (medical CPT codes and descriptions and ICD-9 codes and descriptions) and they continually get added to. I am wondering if it is possible to set up the drop down box so that I can type the code number I want in the field and have it fill in rather than use the drop down box?

AnswerEdit

IF I read the question correctly, this page

http://www.ozgrid.com/Excel/autocomplete-validation.htm

or this google search

http://www.google.co.uk/#hl=en&source=hp&q=excel+autocomplete&aq=5&aqi=g10&aql=&oq=excel+auto&gs_rfai=&pbx=1&fp=6fcfcc50c300c1b7

gives other possible solutions