vba searchble dropdown

[malleshg24]

Hi Team,

Looking dynamic userform which search partial text.

Below is attached file, code is written in Class module,

is there any alternate code available like this.





Thanks
mg

[arnelgp]

see this youtube:
Searchable Drop Down List in Excel (Very Easy with FILTER Function) - YouTube (https://www.youtube.com/watch?v=Z-h2UER3b_0&ab_channel=LeilaGharani)

[malleshg24]

Hi Team,

in attached excel Macro it contains forms,

I want msgbox / or into variable what value user has selected from listbox. only single value.

Huge code Unable to find it.



Thanks
mg

[anish.ms]

Check this out
I got this code from Paul_Hossler from his response in one of the other thread. I just tweaked a little bit here

[arnelgp]

sorry i cannot attached here.
when you open the workbook, on Home tab (far right, there is a button for the movies).
https://www.dropbox.com/scl/fi/2ck67gg4q803mvv41sb0y/agp_Searchable-Dropdown-Simple.xlsm?dl=0&rlkey=20mm48hbetobk3pbr581l74zu

[anish.ms]

Hi,
Can you tell me how did you add the icon in ribbon?

[arnelgp]

you can google it "customize excel ribbon" or "add custom icon in ribbon".
there are many tutorials.

i used Office RibbonX Editor.

[anish.ms]

thank you!
got it



<ribbon> <tabs>
<tab idMso="TabHome" > <group id="customGroup1" label="Movie List" insertAfterMso="GroupEditingExcel" > <button id="customButton1" label="Search Movie" size="large" onAction="ufm" image="Videos-icon" /> </group> </tab>
</tabs> </ribbon>
</customUI>

[malleshg24]

Hi Team,

I resolved my query using sql query, filled listbox from recordset. You can close this ticket. thanks.


Thanks
mg