Extracting the color of a cell with VBA

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
 
D

David M. Marcovitz

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=?=
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Match table shading (color) to Visio color/Transparency 1
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
VBA to add Hyperlink to a Table Cell to a Slide 0
Need help modifying code 0
Fill tringle in a cell with color 1
Layout Guide color 0
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
How do I convert shading to highlighting for specific colors 8

Top