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.
Can anyone help me with this?Please Login or Register to view this content.
Thank you in advance.
IgorExcel create ComboBox list from array.xlsb
Bookmarks