Etienne

Check out Debra Dalgleish's site for how to add a combo-box which allows
auto-complete.

http://www.contextures.on.ca/xlDataVal10.html


Gord Dibben MS Excel MVP

On Tue, 31 Jan 2006 05:13:28 -0800, "Etienne"
wrote:

An existing list of data needs to be linked as a "dropdown list" into another
sheet and a range of cells. The dropdown list should have the feature of
"Auto completing the list" instead of the normal "Validation / List" function
where the data remains fixed in the dropdown list.

Example "some items in a stock list needs to be inserted into another Excel
sheet with the aid of a dropdown list."
Thousands of items are in the list and to browse all without an "Auto
complete function" is not practical.