Create ComboBox list from array

[igormigor]

Hi all,

I like to create list in Combo Box from the values in column B, if the color of the cell A for the given row is Orange [RGB(255, 192, 0)].
The values in column B will not be taken in consideration if the color of cell in column A for same row is not orange [RGB(255, 192, 0)].

The code I've wrote works, just it gives the whole list of values which fits the above criteria. I need to have list in which the values will not be repeated.

Please Login or Register  to view this content.

Can anyone help me with this?

Thank you in advance.

IgorExcel create ComboBox list from array.xlsb

[AlphaFrog]

Try this...

Please Login or Register  to view this content.

[igormigor]

Hi Alpha Frog,
it works perfectly.
Thank you a lot.
Igor