Joe

DV dropdowns do not have the autocomplete feature.

You would have to use a combobox for that.

See Debra Dalgeish's site for help

For the combobox solution see

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


Gord Dibben MS Excel MVP

On Tue, 1 Jul 2008 08:00:02 -0700, Joe H. <Joe
wrote:

I am creating a quote sheet in excel that will need to be filled out quickly
while on the phone with my customers. There is basic info that will be needed
for each quote. The first thing will be the customer name. What would be the
best way to set up a cell to auto select from a list? Let’s say John Doe’s
Lumber Yard calls, is there a way I can start tying “J” and be able to select
John Doe’s Lumber Yard from a list and have it auto fill the cell? I have it
set up right now with a drop down list but it takes just as long to search
threw all my customers in the drop down list than it would to just type it
in. I was thinking if I had a drop down list I could click on the carrot and
type “J” and the list would automatically scroll to the customers beginning
with “J” but this is not the case. I have to manually scroll down and find
the customer. Any suggestions would be greatly appreciated. Thanks.