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.

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.

Thanks Gord, the code was perfect.

"Gord Dibben" wrote:

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.