Have an .xls file with multiple sheets and many objects (Shapes) on of those sheets.
The objects are all rectangles, some of which contain text frames, where I had entered manually some text.
Also, each shape has a name.
Now, I want my VBA Macro to take a specific shape (using its name), and find out if it has text frame in it.
i thought the way to do it is
,where X is the string that is the name of the shape I am testing.Please Login or Register to view this content.
Every example I could find had that type of code above.
But in my case I get "Object doesn't support this property or method" when I call this code.
Also, scanning through Shapes Collection properties, I don't actually see "HasTextFrame" mentioned. Only "HasDiagram".
Would anyone have any suggestions?
Thanks,
a1
Bookmarks