Listboxes are populated by one Combobox selection

Hi all,

I am new to this so please bear with me. In the attached workbook there is 4 columns of data on Sheet1 that I would like to view/organize in a userform via one combobox and two listboxes. I'll describe what each Combobox and Listbox should do below:

ComboBox1 - should show the Clients from range(A2:A37) on Sheet1 but not include duplicates (Client name should only appear once)

ListBox1 - depending on the Client you choose in ComboBox1 the corresponding registration of the Client will be displayed taken from range(B2:B37) on Sheet1 (once again no duplicates... the corresponding registration should only appear once)

ListBox2 - Also, depending on the Client you choose in ComboBox1 the corresponding Product Name and Account will be displayed taken from range (C2:D37) on Sheet1 (once again no duplicates... the corresponding Product Name and Account should only appear once)

Please let me know if this is possible. Thank you

Hi

See if this helps. Also it would be a good idea to name your objects something meaningful it will save you headaches later and your code will be more intuitive. Ex instead of combobox1, cmbOrders

Please Login or Register  to view this content.

Test.xlsm

Thanks