| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
|
#5
|
|||
|
|||
|
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 |
|
#6
|
|||
|
|||
|
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 |
|
#7
|
|||
|
|||
|
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 ---- |
|
#8
|
|||
|
|||
|
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 |
|
#9
|
|||
|
|||
|
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 |
|
#10
|
|||
|
|||
|
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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop down menu | Excel Discussion (Misc queries) | |||
| help with drop down menu data | Excel Discussion (Misc queries) | |||
| add option to drop down menu | Excel Discussion (Misc queries) | |||
| Applying a formula to a drop menu choice | Excel Discussion (Misc queries) | |||
| How do I set up a drop down menu for a validation list? | Excel Worksheet Functions | |||
Hybrid Mode
