ExcelBanter - Word art in excel '07

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Word art in excel '07 (https://www.excelbanter.com/excel-programming/419565-word-art-excel-07-a.html)

ben

Word art in excel '07

Does anyone know the proper method for filling out the text color in wordart
in '07.

Shape.fill.backcolor = color

no longer works. Instead it fills in the background around the text.

Andy Pope

Word art in excel '07

Hi,

Try,

Shape.TextFrame2.TextRange.Font.Fill.ForeColor.RGB = color

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"ben" (remove this if mailing direct) wrote in
message ...
Does anyone know the proper method for filling out the text color in
wordart
in '07.

Shape.fill.backcolor = color

no longer works. Instead it fills in the background around the text.

ben

Word art in excel '07

beautiful.
Thanks andy.

"Andy Pope" wrote:

Hi,

Try,

Shape.TextFrame2.TextRange.Font.Fill.ForeColor.RGB = color

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"ben" (remove this if mailing direct) wrote in
message ...
Does anyone know the proper method for filling out the text color in
wordart
in '07.

Shape.fill.backcolor = color

no longer works. Instead it fills in the background around the text.

All times are GMT +1. The time now is 12:30 PM.