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 |
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 |
All times are GMT +1. The time now is 05:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com