Hi,

This may help you at least understand the problem.
http://spreadsheetpage.com/index.php...heme_colors/#c

Cheers
Andy

Chrisso wrote:
Hi All

I have writen some code so that a user can add a callout shape onto a
cell.

I would like to color the callout shape the same color as the cell the
user selected.

shp.Fill.ForeColor.SchemeColor = r.Interior.ColorIndex

However it seems that the SchemeColor for shapes DOES NOT equal the
ColorIndex used for cells.

Should I use a different property or is there a mapping? Or is this
too hard?

Cheers for any ideas,
Chrisso

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info