I would like to help with a code to filter the list box in terms of the combobox and column number 3 in the list box
I would like to help with a code to filter the list box in terms of the combobox and column number 3 in the list box
Last edited by saftawy1; 04-22-2022 at 07:10 PM. Reason: add attachement
Attach the workbook according to the yellow banner at the top of the page.
Artik
It's not entirely clear what your problem is.
1. If you want the text you are looking for, entered in TextBox1, to be case insensitive, replace this linewith this onePlease Login or Register to view this content.
2. If you want the date to be displayed in your system format rather than the US format, then change this loopPlease Login or Register to view this content.
to thisPlease Login or Register to view this content.
3. If the text is not found, add a condition:Please Login or Register to view this content.
ArtikPlease Login or Register to view this content.
Thank you for your suggestions, but I do not have a problem with my code, but I would like to add a code to filter the list box based on what I choose from the combobox2
hi saftawy1, attached a solution I gave to a 'poster' on this site recently - it enables a search on any selected column of the data according to the selection of the 'option-button'.
I do not understand why you have so much unnecessary code in a simple 'UserForm' application.
Torachan,
Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.
This code does filtering by the checkbox and the combobox together. Is it possible to help make the code work in the checkbox only if the combobox is empty, and with both if the combobox has an option?Please Login or Register to view this content.
Last edited by saftawy1; 04-24-2022 at 11:28 AM. Reason: add a new attachement
Is there any possibility to modify this code or not?
I do not see that code anywhere in your original file.
Grabbing bits of code from here and there and gluing them together is not an efficient way of developing an app.
where did the code come from ???
get away from using 'rowsource' for loading listboxes/comboboxes it is an unstable method and using 'removeitem' is a cumbersome method especially when used with a large data file.
populate using structured tables and arrays.
Last edited by torachan; 04-24-2022 at 10:53 AM.
sorry ,i add a new attachement
run debug your file is nothing like your original query ???????
I uploaded the last file with the code to be modified and it works fine for me
Attachment 778069
no sheet named "report" ????
With ThisWorkbook.Sheets("report").Range("b5:Q2000").ClearContents
What does this have to do with the code I want to modify?
Also the attached file is a thumbnail model of the file I'm working on
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks