Universal Searchable Drop-down List in Excel

#VBA #Userform
In this video, you will learn how to create a universal searchable drop-down list in Excel. It is useful when you have multiple items in your data validation drop-down list. You can use this searchable drop-down to search from multiple drop-down. It is a VBA user form with textbox and list box. In the text box you can type your search text and in the list box you will show the drop-down items. To update the value on excel sheet form the user form, just double click on the list box item or press enter.

Please download the practice file from below given link:

Download our free Excel utility Tool and improve your productivity:

See our Excel Products:

Visit to learn more:

Watch the best info-graphics and dynamic charts from below link:

Learn and free download best excel Dashboard template:

Learn Step by Step VBA:

Website:

Facebook:

Telegram:

Pinterest:

************* Suggested Books *********

************* My Stuff ****************

[Mendelyeev]

P.K, you're amazing! I use almost every tutorial and tip!!! Thank you and Congratulations for excellent work!

[Marya_S]

Very smart and very useful tool. You're the one of the excel contents creators that I appreciate the most. Thank you for your work PK.

[rohitgurung]

This is an ultimate module which really very helpful in many ways....I really appreciate your work and thank you so much....

[departmentcivil]

From India sir, bow to you sir, greatest in the excel, god bless you sir, love you sir. great knowledge great work

[DonovanJenkins]

Hi PK. Thank you so much for this! I have searched for a solution like this before, but never found anything as good as this. I have implemented this solution on a workbook I'm building right now and it works beautifully! I love your videos.

[NR-mhzj]

Very helpful . Keep continue ur service. Ur expert👍

[rajumasih]

Sir ye to super se v uper h really you are a great teacher thank you

[MohAboAbdo]

Thank you very much for this great video and for this most amazing explanation.Thank you so much, Sir.

[MariaSilva-xzyg]

I did not enjoy this video, I LOVED it! Clear and concise explanation, very clever and useful tool. Thanks a lot!

[Mraungnaingthu]

Thank you very much Sir. Great Teacher for excel.

[mennolankhaar]

Exactly what I was looking for. Awesome. I have put it to good use. Thx and keep them coming 👍🏻

[ExcelAutomationByMudit]

Hi PK,
I am working in Aditya Birla Group in Dubai for past 4 years in Field of Excel Automation.
And i must appreciate you for the way you are explaining to the learners.
I usually do not see the basic videos but your thumbnail was too attractive to refuse.
Kudos to Excel.
Also in case you or any of your excel enthusiastic friend want to join for some role ill be happy to help.

From
Mudit Lalwani

[optimisesocialmedia]

That was absolutely thank you so much. I learned tons :)

[VBAGYAN]

SIR

I HAVE NO WORDS FOR YOUR PRAISE
I JUST SAY THAT YOU ARE AWESOME

[NeangBona]

Oh! Thank you sharing! my true king vba code PK!

[shahjn]

VERY GOOD IDEA
Sir now I am making excel userform for my own office
can we use this in my combobox in userform
thanks for help

[djbcybertench]

How can I change the code to show more than 7 rows in the search list ? I would like to see 10 or more rows in the search box. Keep up the good work... your tutorials are very helpful. Thank You.

[muhammed-jameel]

It is really good tutorial keep it up
But I think you can two changes in it
1. Use unload form1 instead of form1.hide
2. When form height is 164 then tabstop of radio buttons will be false also or frame may be visible = false.
Otherwise tab key will effect radio buttons value.

[apoorvsrivastava]

Thank you so much for the video, it really helped
can it be possible for an option to add data in some queue while searching from list which later can be added at once on that column . If yes, what changes should be needed the logic

[RawaeaDesigner]

Sir, how can I write in TextBox1 something other than drop-down menus?