Drop menu in excel, is it possible?

[pericopericone]

Hi,

I want excel to detect text as I type and then show me a list of closely related words.

For example:

If I type:

Appl

I want excel to show me in a drop down menu all the items in a list of items that start with "appl" for example Apple-Red or Apple-McIntosh or Apple-78ct or any word that has appl as its starting letters.

Is this even possible with excel?

[Pete_UK]

Debra Dalgleish shows how you can set up a combo box, which will give you an Auto Complete facility, here:

http://www.contextures.com/xlDataVal10.html

Hope this helps.

Pete