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

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

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Pong" wrote in message
...
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

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 wrote:

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

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Pong" wrote in message
...
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

--

Dave Peterson

Thanks for the corrected link, Dave !

Copying from google and pasting sometimes adds extraneous dashes.
Gotta remember this ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Dave Peterson" wrote in message
...
Copying from google and pasting sometimes adds extraneous dashes.

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

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

"Dave Peterson" wrote:

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 wrote:

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

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Pong" wrote in message
...
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

--

Dave Peterson

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

-----Original Message-----
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
.

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.

Pong wrote:
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

"Dave Peterson" wrote:


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 wrote:

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

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Pong" wrote in message
...

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

--

Dave Peterson




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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 ?
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

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

or...

Lenscrafters.


Max wrote:

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 ?
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

--

Dave Peterson

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

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

or...

Lenscrafters.


Max wrote:

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 ?
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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 Dalgleish wrote:

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

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

or...

Lenscrafters.


Max wrote:

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 ?
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

--

Dave Peterson

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
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

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


On Tue, 22 Mar 2005 09:01:15 -0600, Dave Peterson
wrote:

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 Dalgleish wrote:

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

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

or...

Lenscrafters.


Max wrote:

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 ?
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html