Drop down menu

[Guest]

Hi,

I want to create a drop down menu for my customer list. The drop down menu
should have a auto search function. eg. If I type in "Mic", the drop down
menu will bring me to the customer name close to "Mic". How can I do it?
Can I update the customer list regularly.

Pong

 

[Max]

This previous post by Debra Dalgleish would be of interest:

"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/exc­elfiles.html

Under 'Data Validation', look for 'Data Validation Combobox' "

 

[Dave Peterson]

Copying from google and pasting sometimes adds extraneous dashes.

http://www.contextures.com/exc­elfiles.html
should be:
http://www.contextures.com/excelfiles.html

 

[Max]

Thanks for the corrected link, Dave !

Copying from google and pasting sometimes adds extraneous dashes.

Gotta remember this ..

 

[Guest]

Hi,

Thanks for the quick reply. The sample is almost fit to my needs. But I
have about 500 customer data base and I could not expand the drop down box
more than 7 and 12 rows. Please help.

Pong

 

[Jason Morin]

You can re-create the customer list directly above your
validation cell, and AutoComplete will work. Hide the
list if necessary.

HTH
Jason
Atlanta, GA

 

[Debra Dalgleish]

There are instructions in the workbook for viewing the combobox and
changing its properties. To show more rows, change the ListRows
property, which is currently set at 12.

Hi,

Thanks for the quick reply. The sample is almost fit to my needs. But I
have about 500 customer data base and I could not expand the drop down box
more than 7 and 12 rows. Please help.

Pong

:

 

[Max]

http://www.contextures.com/exc­elfiles.html

should be:
http://www.contextures.com/excelfiles.html

Dave, your eagle-eyed, x-ray vision / experience is telling <bg>!
Visually impossible at a glance to tell the diff between the 2 links (in OE
at least) until one either hovers the mouse over the link or clicks on it ..
Mind sharing any shortcuts to develop/hone such a vision ?

 

[Dave Peterson]

It's got a lot to do with the =subfilter() function <vbg>.

or...

Lenscrafters.

 

[Debra Dalgleish]

Or your recently mentioned sixth sense -- "I see dead links."

It's got a lot to do with the =subfilter() function <vbg>.

or...

Lenscrafters.

 

[Dave Peterson]

I think someone posted that those dashes are visible in some newsreaders and not
in others.

I use Netscape 4.7x and I can see them. I think that OE doesn't show
them--IIRC.

And that may have been my sicksth sense.
....
Or maybe not.

Or your recently mentioned sixth sense -- "I see dead links."

 

[Max]

OE doesn't show them--IIRC.
yup, this seems the case as far as I can see ..
btw, thanks for sharing all of your "dark" vision secrets / senses <bg>

 

[Gord Dibben]

Forte Agent 2.0 shows the dashes and when you copy the text, the dashes come
with.

Makes for some interesting errors when not paying close attention.


Gord Dibben Excel MVP