|
Drop down menu
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 |
| All times are GMT +1. The time now is 09:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com