ExcelBanter - Word Art Object properties in VBA

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

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

- - Word Art Object properties in VBA (https://www.excelbanter.com/excel-programming/293685-word-art-object-properties-vba.html)

Arnie[_5_]

Word Art Object properties in VBA

I have placed several Word Art objects on an Excel sheet. Is there a
way to list the Word Art objects on the sheet and then display their
properties?

So far I have been able to run a macro to manipulate the Word Art
object and that is the only way I have found to discover the name of
the object and make changes to it.

Arnie

All times are GMT +1. The time now is 08:32 AM.