You might like to think about using a combo box, as this has auto-
complete. Debra Dalgleish takes you through it he
http://www.contextures.com/xlDataVal10.html
Hope this helps.
Pete
On Sep 30, 2:11*pm, Aligahk06
wrote:
Dear All,
In data validation we have more than 5000 lists and their corresponding
records.
Looking an item *in the list manually is quite trouble and scrolling *upto
5000 lists is tedious.
Can i have a technique that we can find our list either by serching or
finding techniques once a
particular item list is looked.
Please assist ?
Rgds,
Alighak06