Dear All,
i have a list created, with a lot of customers (its a dropdown list, where
you can roll to the desired customer). Is it possible to do the following: if
i start to write in the customer name; (let's say Hilton), than at Hi it
gives me the Hilton name already (of course if there is no more with Hi start.
I hope it is clear:-)

thx a lot
Peter

See Debra Dalgleish's coverage of the Data Validation/Combo Box topic at her
website:
http://www.contextures.com/xlDataVal10.html

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"Petya" wrote:

Dear All,
i have a list created, with a lot of customers (its a dropdown list, where
you can roll to the desired customer). Is it possible to do the following: if
i start to write in the customer name; (let's say Hilton), than at Hi it
gives me the Hilton name already (of course if there is no more with Hi start.
I hope it is clear:-)

thx a lot
Peter

Petya

In xl2k you can sort your list "ascending" and at each change in the first
letter of your list, insert a cell and place the appropriate letter. In your
dropdown just enter the first letter and the click the dropdown arrow and you
are at the beginning of that part of your list.

Does that help?

Mike Rogers


"Petya" wrote:

Dear All,
i have a list created, with a lot of customers (its a dropdown list, where
you can roll to the desired customer). Is it possible to do the following: if
i start to write in the customer name; (let's say Hilton), than at Hi it
gives me the Hilton name already (of course if there is no more with Hi start.
I hope it is clear:-)

thx a lot
Peter