Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Drop down menu
Is is possible when you have a drop down menu, to have excel short list the
menu as you type in more charcaters of the text. For example a have a list of several hundred customers. I start inputting the first few letters of the customers name, I would like that list of several hundred to be shortened to only include thaise customers that begin with the letters I have typed in. Thanks |
#2
|
|||
|
|||
Think this previous post by Debra Dalgleish would be of help:
"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/excelfiles.html Under 'Data Validation', look for 'Data Validation Combobox' " -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "Ron" wrote in message ... Is is possible when you have a drop down menu, to have excel short list the menu as you type in more charcaters of the text. For example a have a list of several hundred customers. I start inputting the first few letters of the customers name, I would like that list of several hundred to be shortened to only include thaise customers that begin with the letters I have typed in. Thanks |
#3
|
|||
|
|||
I was succesful in adding a combo box but could not get it to work properly.
When I double click it does not show the drop down menu. Is there an easy was to copy the example from Debra into my spreadsheet. What changes doI need to make? "Max" wrote: Think this previous post by Debra Dalgleish would be of help: "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/excelfiles.html Under 'Data Validation', look for 'Data Validation Combobox' " -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "Ron" wrote in message ... Is is possible when you have a drop down menu, to have excel short list the menu as you type in more charcaters of the text. For example a have a list of several hundred customers. I start inputting the first few letters of the customers name, I would like that list of several hundred to be shortened to only include thaise customers that begin with the letters I have typed in. Thanks |
#4
|
|||
|
|||
Ron
Assuming you have Debra's workbook loaded and active. A single-click will show the Data Validation drop-down list to choose from. This is built in the normal DV steps. The combo box you build from scratch so you have both in the same cell. A double-click will allow you to start typing in the box and autocomplete will take over. After you double-click you will also see a smaller inner arrow that you single-click on to get the drop-down list. Kind of a 3-way operation with your choice of options. To make changes, right-click on the sheet tab and "View Code". You make any changes there to the code to reflect your ranges to work upon. Copy the whole thing to a new workbook and start from there. Follow Debra's on-screen instructions to change Combo Box settings. Gord Dibben Excel MVP On Fri, 4 Mar 2005 11:19:03 -0800, Ron wrote: I was succesful in adding a combo box but could not get it to work properly. When I double click it does not show the drop down menu. Is there an easy was to copy the example from Debra into my spreadsheet. What changes doI need to make? "Max" wrote: Think this previous post by Debra Dalgleish would be of help: "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/excelfiles.html Under 'Data Validation', look for 'Data Validation Combobox' " -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "Ron" wrote in message ... Is is possible when you have a drop down menu, to have excel short list the menu as you type in more charcaters of the text. For example a have a list of several hundred customers. I start inputting the first few letters of the customers name, I would like that list of several hundred to be shortened to only include thaise customers that begin with the letters I have typed in. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple selections in a drop down menu | Excel Worksheet Functions | |||
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 |