Hi,

I have a little issue with Listboxes. Here is my situation.

I have a listbox with choices that are not always the same. What I mean by that is that if you, for example, change your choice in another listbox, the choices will change.

(the excel file I added has an example)

Depending on what you choose in the first listbox, the second one will have a different amount of choices aswell. I want the second listbox to show the correct choices, without empty spaces, and with the correct size.

I'm using regular listboxes, so I'm not in a userform.

What macro (because I guess I'll have to use a macro) should I put on the first listbox that will automatically adapt my second listbox accordingly?

Refering to this file:
listbox issue.xlsb

You can try changing the first listbox and see what happens.
I created 3 different listboxes that each show what the unique listbox should be showing.

Thank you!