Self population cells - based on dropdown menu

Hi There

This is what I want - is this possible ?

I have few cells which has a drop down list eg. apple, banana, grape, carrot

Is there any way for the words to auto fill based on the defined list when the first two or three charcters are typed

eg if I type " Ap " the cell will prompt me "apple"

This occurs now in a normal excel sheet column provided the same name was entered above it and there are no spaces between rows.


Is it possible to have this feature when the only source of information for the cell is the drop down menu

I presume I made my point clear - let me know if you want me to explain with an example

Thanks

cross posted at

http://www.excelforum.com/excel-gen...cells-based-on-dropdown-menu.html#post2188415