Dropdown with 300 entries!

[BittenApple]

Hello team,
I need to insert a dropdown with 300 rows on a dashboard I am building. That makes it totally impossible for an end user to go through the list and finds the desired entry.

I wonder what the work around this is. Can combo box filter the data in dropdown by entering only the initial of the entries.

What the solution is?

Regards,

Bita

[HansV]

One option is to use a combo box in combination with some VBA code. See the attached sample workbook.

DataValidationComboClick.xlsm

Another option is two use two or three dependent data validation dropdowns. For example, the user can select one of about 7 main categories from the first one, then one of about 7 subcategories from the second one, and finally one of about 7 items from the third one.

[BittenApple]

Hans,

Thanks for the response,
The code is awesome and almost I understood the code.

Great response.
Thanks for it.
Regards,
GreenTea