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

[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/2ck67...bk3pbr581l74zu

[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