Copying from google and pasting sometimes adds extraneous dashes.
http://www.contextures.com/exc*elfiles.html
should be:
http://www.contextures.com/excelfiles.html
Max wrote:
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
--
Dave Peterson