VBA - Filtered combobox

hi,

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

Please Login or Register  to view this content.

This populates the combobox with product A, B, C, D.
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?

Hello verschelde.steven,

You need to check 9if the product is active or not before adding it to the ComboBox.

If the product is a string that contains the status "active or "not active" then use this code...

Please Login or Register  to view this content.

If the product and it's status are in separate cellsthen use this code...

Please Login or Register  to view this content.