thanks - it does seem to be more painful than it should have to be. I think
MS needs to make it easier for plainfolk. Luckily I know a little programming.

"Ron de Bruin" wrote:

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.