Drop Down lists
I have a list of over 100 items in my drop down (data validation list) I am
looking for a solution to allow me to type in the first 2 or 3 letters of the word so I can narrow my search. Does anyone have a suggestion of how to accomplish this. Thanks mike |
Drop Down lists
Debra Dalgleish shows how you can use AutoComplete with Data Validation by
using a combo-box. Click on this link: http://www.contextures.com/xlDataVal10.html Hope this helps. Pete "mike c" wrote in message ... I have a list of over 100 items in my drop down (data validation list) I am looking for a solution to allow me to type in the first 2 or 3 letters of the word so I can narrow my search. Does anyone have a suggestion of how to accomplish this. Thanks mike |
Drop Down lists
Hi,
Here is a site that uses a non-vba approach for that: http://www.ozgrid.com/Excel/autocomplete-validation.htm -- If this helps, please click the Yes button Cheers, Shane Devenshire "mike c" wrote: I have a list of over 100 items in my drop down (data validation list) I am looking for a solution to allow me to type in the first 2 or 3 letters of the word so I can narrow my search. Does anyone have a suggestion of how to accomplish this. Thanks mike |
All times are GMT +1. The time now is 03:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com