View original (French)

Populate data in a listbox and filter by combobox

genaro_5592 Posted messages 5 Status Member -  
f894009 Posted messages 17417 Registration date   Status Member Last intervention   -
Hello, I am new to VBA Excel and I am looking for the code to populate my data
in "listbox1" and filter by combobox1
Thanks in advance.

2 answers

  1.
    f894009 Posted messages 17417 Registration date   Status Member Last intervention   1 717
     
    Hello,
    to see, file test_V3.xlsm at the bottom
    https://forum.excel-pratique.com/excel/filtrer-listbox-par-une-combobox-83792
    0
    1. genaro_5592 Posted messages 5 Status Member
       
      Hello,
      Thank you, Sir. I will try to do it.
      0
      1. f894009 Posted messages 17417 Registration date   Status Member Last intervention   1 717 > genaro_5592 Posted messages 5 Status Member
         
        Hello,

        file with multiselect listbox to view and modify presence: https://mon-partage.fr/f/T5SwXbVy/
        0
  2. genaro_5592 Posted messages 5 Status Member
     
    Hello,
    I tried everything, it's all good, but I have this bug when I use my combobox1 to start filtering
    my search range "L" and I have 14 cells from A to N

    0
    1. f894009 Posted messages 17417 Registration date   Status Member Last intervention   1 717
       
      Hello,

      the post3 file was not meant for you, it was a clicking error

      Could you make your file available because I can't respond to you unless you've defined something in the Rowsource property of the said listbox.
      0
      1. genaro_5592 Posted messages 5 Status Member > f894009 Posted messages 17417 Registration date   Status Member Last intervention  
         
        I just put the file in practical-excel with the same pseudo name,

        I thank you very humbly for your part.
        0
      2. f894009 Posted messages 17417 Registration date   Status Member Last intervention   1 717 > genaro_5592 Posted messages 5 Status Member
         
        Hello,

        I found it, I'm retrieving and looking at it

        Modified file: https://mon-partage.fr/f/dqi6XF5o/
        You'll need to check the file because I took the first one at the beginning

        The Rowsource property has a drawback; it needs to be deleted, not cleared. You will have to write it each time you use your code in the initialization of the UF
        If there is no Rowsource and you fill the listbox by reading the lines from the sheet. In this case, clear works
        In the file I modified for you, the Rowsource property no longer exists. It’s up to you to decide how to fill the listbox when launching the UF.
        0