Use a combobox Jason

See Debra's site
http://www.contextures.com/xlDataVal10.html


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Jason W" <Jason wrote in message ...
I need to have a drop-down list that autocompletes as I begin to type. I have
844 names to scroll through and it is painful without autocomplete option. I
am using the "validation" type of list for this cell.