Hi All,
I am trying to populate a listbox with unique values based on the criteria found in other columns. And here's an example of the data I want to solve :
<tbody>
</tbody>
In a userform, I have a ComboBox that contains unique values based on column B (already done)
And when I change the value in ComboBox, the list from the listbox fills up according to the criteria I am calling from ComboBox (here I am stuck with the code).
So when I select "left" from combobox, listbox will fill with value
- Item B, and
- Item C
Any help of VBA code for the second question would be greatly appreciated
thanks
I am trying to populate a listbox with unique values based on the criteria found in other columns. And here's an example of the data I want to solve :
A | B | |
1 | Item A | up |
2 | Item B | left |
3 | Item B | left |
4 | Item B | left |
5 | Item C | left |
<tbody>
</tbody>
In a userform, I have a ComboBox that contains unique values based on column B (already done)
And when I change the value in ComboBox, the list from the listbox fills up according to the criteria I am calling from ComboBox (here I am stuck with the code).
So when I select "left" from combobox, listbox will fill with value
- Item B, and
- Item C
Any help of VBA code for the second question would be greatly appreciated
thanks