Dependant Combo boxes, filter and displayed data from another worksheet

Hi jindon, I have opened a new thread as you suggested. I have a specific question on the code you provided above. If I want to point all 3 combo boxes to different columns for the input ranges, where and what exactly I need change in the code. I can see the comment '<-- Col reference for combo3, but what about other combo boxes. I am not a programmer so finding it difficult to work it out. thanks

I hope someone else can understand what you are trying to and solve it for you.

There maybe logical conflicts in your explanation.

Multiselect listbox1 select 3 items, what will be the list of 2nd listbox?
when multiple item selected from llistbox2, list in listbox3? and the result?

etc.

Anyway it will be so complicated, so I don't want to do it....

Hi again, my question here wasn't about listboxes etc. It's about the code you wrote in response to my original thread above for combo1 combo2 and combo3. What do i need change in the code to point combo2 or combo1 to different colomus to change their input range. Thank you.

Hi Jindon, I am trying re-use the code you kindly wrote above in your response on 17-01-2013, 10:50 PM above.
I am using this in a similar workbook in Excel 2013, trying to achieve same thing. But in the data I now have a date column formatted as dd/mm/yyyy. But whenever the data is filtered and displayed in "Filter" sheet, the date changes to American mm/dd/yyyy format. Even in the column it is displayed is pre-formatted to dd/mm/yyyy. Is there anything could be done to ensure the date remains as it's? Thanks