Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hey all,
I am trying to label a couple of text boxes that are grouped together within a rectangle. ActiveChart.Shapes("Group 29").Select Selection.ShapeRange.Ungroup.Select ActiveChart.PlotArea.Select ActiveChart.Shapes("Group 28").Select Selection.ShapeRange.Ungroup.Select ActiveChart.PlotArea.Select ActiveChart.Shapes("Text Box 17").Select Selection.Characters.Text = Sheets(Idx + 1).Range("D16") ActiveChart.Shapes("Text Box 18").Select Selection.Characters.Text = Sheets(Idx + 1).Range("E16") Selection.ShapeRange.Regroup.Select ActiveChart.Shapes("Rectangle 13").Select Selection.ShapeRange.Regroup.Select Unfortunately, the GROUP ID changes each time I regroup so that what says "Group 29" now becomes "Group 30"? Any work around for this? Lance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Assign a text to a rectangle | Excel Discussion (Misc queries) | |||
Text Box vs. rectangle, what is the difference? | Excel Discussion (Misc queries) | |||
text does not update in rectangle box | Excel Programming | |||
Change text in rectangle shape | Excel Programming | |||
Add text to a rectangle in VBA | Excel Programming |