Drop down menu-short list the menu

Is is possible when you have a drop down menu, to have excel short list the
menu as you type in more charcaters of the text. For example a have a list
of several hundred customers. I start inputting the first few letters of the
customers name, I would like that list of several hundred to be shortened to
only include thaise customers that begin with the letters I have typed in.

Thanks

Think this previous post by Debra Dalgleish would 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 <at>yahoo<dot>com
----
"Ron" <[email protected]> wrote in message
news:[email protected]...
> Is is possible when you have a drop down menu, to have excel short list
the
> menu as you type in more charcaters of the text. For example a have a
list
> of several hundred customers. I start inputting the first few letters of
the
> customers name, I would like that list of several hundred to be shortened
to
> only include thaise customers that begin with the letters I have typed in.
>
> Thanks

I was succesful in adding a combo box but could not get it to work properly.
When I double click it does not show the drop down menu. Is there an easy
was to copy the example from Debra into my spreadsheet. What changes doI
need to make?

"Max" wrote:

> Think this previous post by Debra Dalgleish would 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 <at>yahoo<dot>com
> ----
> "Ron" <[email protected]> wrote in message
> news:[email protected]...
> > Is is possible when you have a drop down menu, to have excel short list
> the
> > menu as you type in more charcaters of the text. For example a have a
> list
> > of several hundred customers. I start inputting the first few letters of
> the
> > customers name, I would like that list of several hundred to be shortened
> to
> > only include thaise customers that begin with the letters I have typed in.
> >
> > Thanks
>
>
>

Ron

Assuming you have Debra's workbook loaded and active.

A single-click will show the Data Validation drop-down list to choose from.

This is built in the normal DV steps.

The combo box you build from scratch so you have both in the same cell.

A double-click will allow you to start typing in the box and autocomplete will
take over.

After you double-click you will also see a smaller inner arrow that you
single-click on to get the drop-down list.

Kind of a 3-way operation with your choice of options.

To make changes, right-click on the sheet tab and "View Code".

You make any changes there to the code to reflect your ranges to work upon.

Copy the whole thing to a new workbook and start from there.

Follow Debra's on-screen instructions to change Combo Box settings.


Gord Dibben Excel MVP


On Fri, 4 Mar 2005 11:19:03 -0800, Ron <[email protected]> wrote:

>I was succesful in adding a combo box but could not get it to work properly.
>When I double click it does not show the drop down menu. Is there an easy
>was to copy the example from Debra into my spreadsheet. What changes doI
>need to make?
>
>"Max" wrote:
>
>> Think this previous post by Debra Dalgleish would 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 <at>yahoo<dot>com
>> ----
>> "Ron" <[email protected]> wrote in message
>> news:[email protected]...
>> > Is is possible when you have a drop down menu, to have excel short list
>> the
>> > menu as you type in more charcaters of the text. For example a have a
>> list
>> > of several hundred customers. I start inputting the first few letters of
>> the
>> > customers name, I would like that list of several hundred to be shortened
>> to
>> > only include thaise customers that begin with the letters I have typed in.
>> >
>> > Thanks
>>
>>
>>