How to populate a list box with multiple values found via VLOOKUP

Hi guys,

I need help to populate a List Box with multiple values depending on the selection the user previously made in a combo box.

For instance:

If the value "Max Weber" is selected in the Combo Box, the code should look for all the titles Max Weber wrote (which are listed in a worksheet) and populate them into the list box.

I've been trying to solve this for weeks unsuccessfully.

Thank you very much for your help,

Juli

Hi,

Instead of Vlookup use the for loop to fill the adjacent combo box.

Eg. if the combo box value is "Max Weber", trigger the combo box2

Clear the combo box2
fill the Titles one by one where the author Max Weber found.

Regards,
Lokesh

Hi lokicl,

Thanks for your answer. I didn't quite get it though. Should I transforme the list box into a combo box?
Could you please write the code where the combo box 2 is populated?

Tks,

Anyone? Please?

Hi @protonLeah,

could you see this thread again?

Thanks,