Hi all,

I was wondering if there is a feature that will allow predictive text., can this be done using existing feature or do I need to wrtie custom vba code for this for a particular cell. I have a list of records over 100, I dont want users to scroll down all 100 records, so is there a way of creating predictive text..

Excel version 2007 is what im using . Can anybody help me if there are any code that i can use to acheive the above