How about the color property, rather than the colorindex?

--
HTH

Bob Phillips

"ExcelMonkey" wrote in message
...
Is is possible to load the interior colours of a range of cells into
control?
That is I have a range A1:A5 -all of which have different interior cell
colours. I want to be able to pass these actual interiour colours (not
their
interior colour numbers) to a control and choose them for search criteria.
So effectively, upon displaying the colours, I decide that I want the
colour
of cell A1 (cell.InteriorColour = Yellow), and I search for other cells
with
that colour.

I know I can also use the John Walkenbach colour palette and potentially
load it with the colours from this range and then turn the enable
propertly
of the remaining buttons to FALSE if need be.

Thanks