Drop down menu

P

Pong

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
 
M

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' "
 
P

Pong

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
 
J

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
 
D

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

:
Click to expand...
 
D

Dave Peterson

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

or...

Lenscrafters.
 
D

Debra Dalgleish

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

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

or...

Lenscrafters.
Click to expand...
 
D

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.

Debra said:
Or your recently mentioned sixth sense -- "I see dead links."
Click to expand...
 
M

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>
 
G

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
 
Top