x2 Dependent ComboBoxes with Unique Values

Hi all,

I've searched all the threads and cant find a solution that works to my problem. I have two Combobox's, the first of which should present a "unique" set of values from sheet1 column A, and the second should present the corresponding unique values from sheet1 column B. I can get the first bit working but can't get the population of the second Combobox (see attached).

Thanks

Try this:-

You could use ADO

Please Login or Register  to view this content.

Then call getdata from the combobox1 change event:

Please Login or Register  to view this content.

How about

Please Login or Register  to view this content.

That's great, works really well.

Just now trying to integrate this into the other code that writes the data from other comboboxes and textboxes from the same userform to sheet "Data" and im not sure how to get that to work together. Combobox 1&2 above are now called Combobox 4&5. I've added all the code together below so you can see what it is.

Please Login or Register  to view this content.

These 2 lines

Please Login or Register  to view this content.

Need to go at the very top of the module, before any code.
If you are still having problems, then you will need to supply another workbook with the modified userform & data

Got it working, thanks for your help.

Glad we could help & thanks for the feedback