least prefix matching in a lookup list

[Broekmannr]

If one has a long drop down list, to look for items lower on the list e.g.
starting with the letter "T", if one hits the T key, the list should scroll
down so that all items starting with T are in view.

Can this be done?

 

[figdatbong]

Please forgive me if I've got the wrong end of the stick here...I often do.

I think the solution to this depends on what your objectives are but, if you
have a list of items on an Excel worksheet and a name associated with that
list, you can use the ComboBox control to acheive what you want. The
'ListFillRange' property of the ComboBox control should be set to the name
associated with your original list.

Hope this helps?

 

[Shane Devenshire]

Hi,

This is how the Control Toolbox combobox works. But this is not how the
Form's combobox or the Data, Validation, List command work. Although you can
make the Data, Validation work that way.

To add a Control Toolbox combobox right click any toolbar and choose Control
Toolbox. For examples of that with Data Validation check out:

http://www.ozgrid.com/Excel/autocomplete-validation.htm
http://www.contextures.com/xlDataVal10.html

 

[L. Howard Kittle]

Try this.

Sort the list decending and then at the start of the A list, enter a single
A. Do the same with all the letters of the alphabet, A to Z.

Now hit the down arrow on your data valaditation cell and type in the
alphabet letter of the list you want. DO NOT hit enter. Leave the data
validation cell in the EDIT mode. Now click on the down arrow, it will take
you to the list.

HTH
Regards,
Howard

 

[Ashish Mathur]

Hi,

You may refer to question 44 of the my site -
http://ashishmathur.com/replies.aspx

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com