Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation - In cell drop Down List
My Data Validatio drop down has 30,000 rows. I need to do the following
1.Increase the number of rows shown from 8 to 50 2.Allow users to type in the drop down to filter their search. For example when they are in the drop down and type "B" it brings up those list choices that start with "B". Any help is greatly appreciated |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation - In cell drop Down List
Hey,
Pt 1 - as far as I know there is no way to increase the number of rows but someone may be able to correct me on that. Pt2 - Can't do it with validation but you can if you embed a combo box with it's appropriate coding to load it with the selection options and what to do with the selection. If you want to avoid any coding you could introduce a 2 stage process where dropdown 1 is 'Select starting letter' (A-Z) and then show a second dropdown to display only options beginning with that letter. This can be done without code. HTH Giz "VandyBill" wrote: My Data Validatio drop down has 30,000 rows. I need to do the following 1.Increase the number of rows shown from 8 to 50 2.Allow users to type in the drop down to filter their search. For example when they are in the drop down and type "B" it brings up those list choices that start with "B". Any help is greatly appreciated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DROP DOWN LIST DOES NOT APPEAR USING DATA VALIDATION | Excel Discussion (Misc queries) | |||
BUG? : data validation in-cell drop down list is not displaying | Excel Discussion (Misc queries) | |||
Data Validation Drop Down List - Always Show | 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 |