Filter worksheet data using 4 dependant comboboxes and populate in 'ListBox' on a userform

http://www.excelforum.com/excel-prog...-combobox.html
Hi All,

In the attached file,

Given:
1) In 'Sheet1" my data are in Column A,B,C,D,E,F&G. On the userform, there are 4 'ComboBoxes' and 1 'ListBox'.

Required: As Userform activates, I want to
1) Populate whole data from 'Sheet1' in the 'ListBox1".
2) Populate 'Column A' data in 'ComobBox1'

Then,
3) Based on 'ComboBox1' selection populate matching 'Column B' data in 'ComboBox2".( Also, update 'ListBox1')
3) Based on 'ComboBox1' and 'ComboBox2' selections populate matching 'Column C' data in 'ComboBox3"".( Also, update 'ListBox1')
4) And finally based on 'ComboBox 1, 2 & 3", populate 'ComboBox4' from 'Col D' also update 'listbox1'

I used the code from above link, but unfortunately it did not work.

Please help me ! I have attached the file.

Thanks
p_nayak

Hi p_nayak

Try the Code in the attached. It appears to work on your sample file...let me know of issues.

Hi p_nayak

Try the Code in the attached...

You're welcome...glad I could help. Thanks for the Rep.

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

Hi laurentaylor

Welcome to the Forum!!!

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.