Extracting the color of a cell with VBA

  • Thread starter Thread starter Barb Reinhardt
  • Start date Start date
B

Barb Reinhardt

I can extract the text in a cell of a table using this

myString = myShape.Table.Cell(myRowVal, myColVal).Shape.AlternativeText

How do I get the background color for the same cell using VBA? I know how
to convert the color to the 3 components.

Thanks,
Barb Reinhardt
 
If you change .AlternativeText to:

..Fill.ForeColor.RGB

is that what you are after?

--
David M. Marcovitz
Microsoft PowerPoint MVP
Author of _Powerful PowerPoint for Educators_
http://www.PowerfulPowerPoint.com/

=?Utf-8?B?QmFyYiBSZWluaGFyZHQ=?=
 
Back
Top