software

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

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

Etienne

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

www.contextures.on.ca/xlDataVal10.htmlGord Dibben MS Excel MVP

On Tue, 31 Jan 2006 05:13:28 -0800, quot;Etiennequot;
gt; wrote:

gt;An existing list of data needs to be linked as a quot;dropdown listquot; into another
gt;sheet and a range of cells. The dropdown list should have the feature of
gt;quot;Auto completing the listquot; instead of the normal quot;Validation / Listquot; function
gt;where the data remains fixed in the dropdown list.
gt;
gt;Example quot;some items in a stock list needs to be inserted into another Excel
gt;sheet with the aid of a dropdown list.quot;
gt;Thousands of items are in the list and to browse all without an quot;Auto
gt;complete functionquot; is not practical.Thanks Gord, the code was perfect.

quot;Gord Dibbenquot; wrote:

gt; Etienne
gt;
gt; Check out Debra Dalgleish's site for how to add a combo-box which allows
gt; auto-complete.
gt;
gt; www.contextures.on.ca/xlDataVal10.html
gt;
gt;
gt; Gord Dibben MS Excel MVP
gt;
gt; On Tue, 31 Jan 2006 05:13:28 -0800, quot;Etiennequot;
gt; gt; wrote:
gt;
gt; gt;An existing list of data needs to be linked as a quot;dropdown listquot; into another
gt; gt;sheet and a range of cells. The dropdown list should have the feature of
gt; gt;quot;Auto completing the listquot; instead of the normal quot;Validation / Listquot; function
gt; gt;where the data remains fixed in the dropdown list.
gt; gt;
gt; gt;Example quot;some items in a stock list needs to be inserted into another Excel
gt; gt;sheet with the aid of a dropdown list.quot;
gt; gt;Thousands of items are in the list and to browse all without an quot;Auto
gt; gt;complete functionquot; is not practical.
gt;
gt;