| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I select form a drop down box by typing the first part?
I have created a drop down box with many entries in it. Is there a way I can
begin typing and have it find the first match and then select with the mouse the right one? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I select form a drop down box by typing the first part?
Data Validation drop-downs do not allow for autocomplete.
To get that feature you need a combo-box. Debra Dalgleish has done the work for you. http://www.contextures.on.ca/xlDataVal10.html Gord Dibben Excel MVP On Tue, 22 Nov 2005 12:45:05 -0800, StacieKTU wrote: I have created a drop down box with many entries in it. Is there a way I can begin typing and have it find the first match and then select with the mouse the right one? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I select form a drop down box by typing the first part?
Thank you so much!
"Gord Dibben" wrote: Data Validation drop-downs do not allow for autocomplete. To get that feature you need a combo-box. Debra Dalgleish has done the work for you. http://www.contextures.on.ca/xlDataVal10.html Gord Dibben Excel MVP On Tue, 22 Nov 2005 12:45:05 -0800, StacieKTU wrote: I have created a drop down box with many entries in it. Is there a way I can begin typing and have it find the first match and then select with the mouse the right one? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| advanced: synchronizing data value across two worksheet drop boxes | Excel Worksheet Functions | |||
| how do I add data validation dropdown lists to a Form | Excel Worksheet Functions | |||
| Dynamic Formulas with Dynamic Ranges | Excel Worksheet Functions | |||
| How do I select cells and make the info populate into a form? | Excel Worksheet Functions | |||
| Create a drop down in XL cell to select date | Excel Worksheet Functions | |||
Linear Mode
