Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change text in rectangle shape
Rectangle 1 aaa
Rectangle 2 bbb Rectangle 3 Rectangle 4 ddd From the list above I use a macro to change the text Sub NameShapes() Sheets("yrousheet").Select For Each c In [setup!a4:a15] ActiveSheet.Shapes(c).TextFrame. _ Characters.Text = c.Offset(0, 1) Next c End Sub -- Don Guillett SalesAid Software "Finance guy" wrote in message ... How can I enumerate through all worksheets and rectangles and add a text string to all textboxes all of them currently say ©2006 I need to change it to 2007. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rectangle shape round top corners only | Excel Discussion (Misc queries) | |||
Text Box vs. rectangle, what is the difference? | Excel Discussion (Misc queries) | |||
Changing text in a rectangle (shape) using a macro | Excel Programming | |||
Change Shape Text | Excel Worksheet Functions | |||
Add text to a rectangle in VBA | Excel Programming |