Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation with Drop-down list
While using data validation a drop down list becomes available. This is a
very useful tool. However the drop down list does not accept first typed character(s) to show only the data starting with that/these character(s). What do I need to do to make this work??? On the contrary with Filters on a database this works perfectly. Thank you. UlrikLovesHorses |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation with Drop-down list
Hi
Using DV to create dropdown selection lists, does not provide this functionality. To provide that functionality, you would need to use a Combo Box. Debra Dalgleish has examples of both at her site. http://www.contextures.com/xlDataVal10.html There is also a downloadable example file I created, using code to create a dropdown list with single letters of the alphabet inserted. Then, you can type G, for example, and be taken straight to the part of the list beginning with G. http://www.contextures.com/DataValHeadings.zip -- Regards Roger Govier "Ulrik Loves Horses" wrote in message ... While using data validation a drop down list becomes available. This is a very useful tool. However the drop down list does not accept first typed character(s) to show only the data starting with that/these character(s). What do I need to do to make this work??? On the contrary with Filters on a database this works perfectly. Thank you. UlrikLovesHorses |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation with Drop-down list
A ComboBox behaves like you want.
Regards, Stefi €˛Ulrik Loves Horses€¯ ezt Ć*rta: While using data validation a drop down list becomes available. This is a very useful tool. However the drop down list does not accept first typed character(s) to show only the data starting with that/these character(s). What do I need to do to make this work??? On the contrary with Filters on a database this works perfectly. Thank you. UlrikLovesHorses |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation Drop-Down List | Excel Discussion (Misc queries) | |||
DROP DOWN LIST DOES NOT APPEAR USING DATA VALIDATION | Excel Discussion (Misc queries) | |||
Missing Drop Down list -Data Validation | Excel Discussion (Misc queries) | |||
Drop down list in Data Validation | Excel Discussion (Misc queries) | |||
Data Validation using List (But needs unique list in drop down lis | New Users to Excel |