GIGeof
02-23-2021, 03:33 PM
Hello all,
I'm trying to create a file with multiple selection in 3 consecutive listbox. The idea being that the first listbox allows you to narrow down the content of the second one and the combination of what you select in the first and the second listbox gives you the relevant content in the 3rd listbox. A bit like if you had 3 columns in Excel where you would first filter the first one, then the second one and then you would have the possibilities in the 3rd column popping-up.
I have the file attached. But the macro doesn't seem to cross choices based on listbox 1 and listbox 2 to select what's being shown in listbox 3. I seem to miss a step in the code and I don't know where.
More precisely, currently for example if i select Adele in listbox 1 and piano in listbox2, i should have A1, FA2, QA2 showing in listbox 3. But for now I get a long list of 14 possibilities popping-up and it's not what i need. it seems that the listbox3 is only depending on listbox2, not on the combination of listbox 1 and listbox 2.
Have you got an idea where the issue is by any chance?
Cheers,
Geoffrey
I'm trying to create a file with multiple selection in 3 consecutive listbox. The idea being that the first listbox allows you to narrow down the content of the second one and the combination of what you select in the first and the second listbox gives you the relevant content in the 3rd listbox. A bit like if you had 3 columns in Excel where you would first filter the first one, then the second one and then you would have the possibilities in the 3rd column popping-up.
I have the file attached. But the macro doesn't seem to cross choices based on listbox 1 and listbox 2 to select what's being shown in listbox 3. I seem to miss a step in the code and I don't know where.
More precisely, currently for example if i select Adele in listbox 1 and piano in listbox2, i should have A1, FA2, QA2 showing in listbox 3. But for now I get a long list of 14 possibilities popping-up and it's not what i need. it seems that the listbox3 is only depending on listbox2, not on the combination of listbox 1 and listbox 2.
Have you got an idea where the issue is by any chance?
Cheers,
Geoffrey