create an automatic complete list from existing data in the sheet

[Guest]

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.

 

[Gord Dibben]

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

 

[Guest]

Thanks Gord, the code was perfect.

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