Populate a listbox with some criteria

[ecoplan]

Hello! I would like to thank everyone for maintaining a great helping community.

I have a hard time figuring how to populate a listbox with some criterias. So, I have a sheet with tasks to do each month, the dates represent when the task has been done. A "0" means it has not been done yet:

Task......................| Task category... | January ....| February...| March...........| April...........| ...
1 Review procedure.| Administrative | 2012-01-21.|.........0......| 2012-03-02 | 2012-04-07
2 Cleaning .............| Operations......| 2012-01-02 | 2012-02-19|.......0.........| 2012-04-22

My userform has 2 combobox one to select the "Task category" and one to select the month, and a listbox that will show the tasks that haven't been done. For example, if I chose "Administrative" and February from my comboboxes, I should see "Review procedure" in the listbox.

Here's the link of my dummy excel worksheet for example! https://www.dropbox.com/s/u3dmxgcytao4kko/workbook.xls
Thanks!

 

[Mohammad Basem]

Welcome to the forum!

Have a look at this file

 

[ecoplan]

You are a gentleman and a scholar, sir! Thank you very much!

 

[Mohammad Basem]

Thank you for your nice words, but I am not a scholar.

Al-hamdullah, glad I could help and thank you again for providing the feedback.