Data Validation with Drop-down list

U

Ulrik Loves Horses

While using data validation a drop down list becomes available. This is a
very useful tool.
However the drop down list does not accept first typed character(s) to show
only the data starting with that/these character(s). What do I need to do to
make this work??? On the contrary with Filters on a database this works
perfectly.

Thank you.


UlrikLovesHorses
 
R

Roger Govier

Hi

Using DV to create dropdown selection lists, does not provide this
functionality.
To provide that functionality, you would need to use a Combo Box.

Debra Dalgleish has examples of both at her site.
http://www.contextures.com/xlDataVal10.html
There is also a downloadable example file I created, using code to create a
dropdown list with single letters of the alphabet inserted.
Then, you can type G, for example, and be taken straight to the part of the
list beginning with G.
http://www.contextures.com/DataValHeadings.zip
 
S

Stefi

A ComboBox behaves like you want.

Regards,
Stefi

„Ulrik Loves Horses†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation 1
data validation fonts differ in drop down box 1
Remove blank cells from data validation drop down box 3
Data Validation List Names 2
Drop Down List Unavailable 1
Excel 2003-Data Validation drop down list not working? 2
Data Validation drop-down width, with named range source (XL03 and 4
Drop Down Lists 2007 10

Top