This previous post by Debra Dalgleish would be of interest:

"Although data validation doesn't support autocomplete, there's a sample
file here that provides a combobox from which you can select one of the
values from the data validation list. In the combobox, you can enable
autocomplete:

http://www.contextures.com/exc*elfiles.html

Under 'Data Validation', look for 'Data Validation Combobox' "

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Pong" wrote in message
...
Hi,

I want to create a drop down menu for my customer list. The drop down
menu
should have a auto search function. eg. If I type in "Mic", the drop
down
menu will bring me to the customer name close to "Mic". How can I do it?
Can I update the customer list regularly.

Pong