i have a excel table looking like this
product A, active
product B, not active
product C, active
product D, active
to populate a combobox on a userform, i use the following code
This populates the combobox with product A, B, C, D.
Please Login or Register to view this content.
However, i would like to populate the combobox with only the active products, so only A, C and D.
I have no idea how to adjust the code.
can anyone help?