VBA question for Steve

  • Thread starter Thread starter Edward
  • Start date Start date
E

Edward

Hi Steve,
I know you are possibily the only person who has worked with this stuff
I have the following code
..Cell(li, 1).Shape.Fill.BackColor.SchemeColor = ppAccent1
which is part of my table cells and instead of inserting a color explicitly
I want to use accent1 color but for some reason this code just applies white
to the cell background.
I don't want to set a specific color here because i have a customized color
scheme and I wnat the table automatically change its cell color when I copy
it into another PP with a different colorscheme.

by the way the following code works fine
..Cell(li, 1).Shape.Fill.Solid
which applies the fill color to a given cell.
 
Hi Edward,

Use the ForeColor property to set the fill. The BackColor is always the 2nd
color and used for example in case of a two color gradient or a pattern fill
only.

Regards,
Shyam Pillai

Animation Carbon: http://www.animationcarbon.com
 
Thanks,
It worked but I had to add the following code as well
..Cell(li,1).Shape.Fill.Solid
which seems should only be used for fill color and not accents , but as I
said it is working now.
 
Back
Top