populate 4 combobox based on dependant combobox

good day

i have a sheet with various columns eg. DISTRICT, TOWN, NAME, RATE. In another workbook i have a form with which i am calling the values in the first workbook.
i wish to populate the first combobox with the values from DISTRICT, the second combobox(TOWN) then needs to go see which values in TOWN is listed against that district in the first workbook and populate that combobox.
the third combobox then looks at the value selected in the TOWN combobox, go see what names are listed against that in the first workbook and populate the NAMES combobox with those names. lastly, the RATE combobox looks at the value selected in the NAMES combobox, go see what rates are listed against that in the first workbook and populate the RATES combobox with those values...

any assistance is highly appreciated.

Hi Blue,

I am looking for similar kind of solution, so i usded your code. Unfortunately it did not work. It could only populate the 'Combobox1'.Other Comboboxed failed to populate.
Finally, based on all the 4 Combobox selection, I want those rows to be populated in the 'ListBox'. I have attached the excel file.

Someone please help me. I appreciate your time and effor.

By the way, this is my first post in the forum

Thank you,
Pratap

Hi Blue,

Thanks, I will start a new thread.

p_nayak

thank you Blue, i eventually did this:

Please Login or Register  to view this content.