royUK : I have been quite elaborate in my explanation. To simply put, I expect my listboxes to be interdependent in terms of their selected values and finally apply the filter based on the selections. it is demonstrated in the attachement for listboxes named "Source" and "Name of Projects"
If you do not understand, thats ok, but I don't agree that my requirement and explanation are not comprehensible by anyone at all and also I stated earlier, I am just starting to work with VBA and its normal that whatever I could gather from the help of other forums and forum members, I implemented.
If you are not able to help, it would be just enough to leave a comment as such instead of keep on pointing out that my explanation is not clear or implying that I am not quite sure of my requirement
The end purpose of the userform is to effect a filter to the master data which is a table called "DynamicPath_2" located in the sheet"MDB"