Hi All,

I have a data validation list in a cell having more than
500 items.

is it possible to have selected items to show on the drop
down list based on the first letter/letters i enter in
the cell? My list is already sorted alphabatically.

like if i type M in my cell the dropdown list show only
items starting M and in case i enter ME all items
startinf ME and like wise..?

TIA

Soniya

Soniya,

If the source of the list was an Excel range, you could use worksheet event
code to take the cell input (it could be 1, 2 or more chars), and find all
items starting with that value and populate the Data Validation list with
it.

Thing is, you could not use the same cell as the DV as it will fail
validation, so the start string would need to be another cell. Is that okay?
If so, I will knock up some code to demonstrate it.

--

HTH

Bob Phillips

"Soniya" wrote in message
...
Hi All,

I have a data validation list in a cell having more than
500 items.

is it possible to have selected items to show on the drop
down list based on the first letter/letters i enter in
the cell? My list is already sorted alphabatically.

like if i type M in my cell the dropdown list show only
items starting M and in case i enter ME all items
startinf ME and like wise..?

TIA

Soniya