For the autocomplete, you would need a ComboBox

See Debra's site for this.

http://www.contextures.on.ca/xlDataVal10.html

For the add new items query see Debra's site at

http://www.contextures.on.ca/excelfiles.html#DataVal

DV0038 - Flexible Item List -- Use formulas to automatically add new unique
items to a data validation dropdown list. Sample file from Ron Coderre.
DataValFlexList.zip 7kb

Download Ron's sample file.


Gord Dibben MS Excel MVP

On Mon, 28 Jan 2008 10:47:00 -0800, Morfeo
wrote:

hey how's it going?

look, i have created my data validation with a list, it is a list of
customers and vendors, but i would like, when i type the first letter, it
shows me all the data that i have with that letter, i hope it is possible,
and i hope also you can help me.

about the validation too, i would like, in my validation drop drown list, i
would like a caracter that says, " add new" so that way when o want to create
a customer or a vendor, it shows me a window or something to create the new
caracter, i do not know if that is possible too.

thank you for all your information granted.