Extracting the color of a cell with VBA

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Barb Reinhardt - 05 Feb 2008 19:09 GMT

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

Reply to this Message

David M. Marcovitz - 05 Feb 2008 20:05 GMT

If you change .AlternativeText to:

.Fill.ForeColor.RGB

is that what you are after?

Signature

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

=?Utf-8?B?QmFyYiBSZWluaGFyZHQ=?=
<BarbReinhardt@discussions.microsoft.com> wrote in
news:202AEAE5-7353-49DE-B153-B270A96C87BB@microsoft.com:

> I can extract the text in a cell of a table using this
>
[quoted text clipped - 6 lines]
> Thanks,
> Barb Reinhardt

Reply to this Message

John Wilson - 05 Feb 2008 20:24 GMT

As David says. I would also change the original .AlternativeText to
.TextFrame.TextRange

Signature

Amazing PPT Hints, Tips and Tutorials

http://www.PPTAlchemy.co.uk
http://www.technologytrish.co.uk
email john AT technologytrish.co.uk

> I can extract the text in a cell of a table using this
>
[quoted text clipped - 5 lines]
> Thanks,
> Barb Reinhardt

Reply to this Message