Perhaps this recent post by Debra Dalgleish might be of help:

Although data validation doesn't support autocomplete, there's a sample
file here that provides a combobox from which you can select one of the
values from the data validation list. In the combobox, you can enable
autocomplete:

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

Under 'Data Validation', look for 'Data Validation Combobox'

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Pitbull" wrote in message
...
Hey All!

I am trying to do something in Excel that is available in
Access.

For example, I have a database on sheet1 with a bunch of
names and other columns.
Ex:
Bill
Bob
Billy
Boris
Brent
Brad

Now, on sheet 2, I would like to have some kind of tool
that would tell me what is available when I type the
begining of the name.

For example, If I type
"Br" I would like to have it say: choices are Brent and
Brad. (actually, in a Drop Down would be awesome!)
When I type "B", I would have all the Bs in the Drop Down.

Just like access does. It this something that is possible
in Excel?


Thanks in advance for the answers!

Pitbull :)