Predictive Text

[VisualBasic]

Hi all,

I was wondering if there is a feature that will allow predictive text. 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 this be done with existing features or do I need to write some VBA code, if so please help

 

[mikerickson]

There is an autofill feature.
There is an autofilter that can be used to show an entry.

Where would the user be entering this predictive text? In a cell? in a userform?

 

[VisualBasic]

In a cell..

can this be done?

 

[mikerickson]

AutoFill is about the only feature that could be described as predictive text for cell entry.

 

[VisualBasic]

Thanks that worked.