adamsm
06-20-2010, 06:59 AM
Hi,
In my workbook; the column “B” of rows 5 and 6 contain the serial Number “0697”.
Row 7 of the same column has the text “0698”. And again the same column of row 8 has the serial Number “0697”.
Supposing I want to filter all the rows that have “0697” from my user form list box I get only the rows 5 and 6 filtered in the list box even though the worksheet shows all the three rows where it contains the text “0697”.
How could I change the code so that it populates the list box with all the three rows where it contains the text “0697”.
I've attached the workbook for your reference.
Any help on this would be kindly appreciated.
In my workbook; the column “B” of rows 5 and 6 contain the serial Number “0697”.
Row 7 of the same column has the text “0698”. And again the same column of row 8 has the serial Number “0697”.
Supposing I want to filter all the rows that have “0697” from my user form list box I get only the rows 5 and 6 filtered in the list box even though the worksheet shows all the three rows where it contains the text “0697”.
How could I change the code so that it populates the list box with all the three rows where it contains the text “0697”.
I've attached the workbook for your reference.
Any help on this would be kindly appreciated.