locate to particular in a dropdown list
 

I have a list of customers (in alphabetical order) as a drop down list. I
would like the list to locate customers closer to what is typed in the box.
for example say my list is
Alpha computers
Balloons
Eric and co
Financial services
Formal wear

If start typying E in the cell dropdown list should start with Eric & Co and
if I type FO then list should start with Formal wear.

Is there a way to do it?

locate to particular in a dropdown list
 

Use a combo box instead of a DV list.
--
John C


"Prema" wrote:

I have a list of customers (in alphabetical order) as a drop down list. I
would like the list to locate customers closer to what is typed in the box.
for example say my list is
Alpha computers
Balloons
Eric and co
Financial services
Formal wear

If start typying E in the cell dropdown list should start with Eric & Co and
if I type FO then list should start with Formal wear.

Is there a way to do it?