View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Linking to specific cells in pivot table Linking to specific cells in pivot table is offline
external usenet poster
 
Posts: 64
Default Editing text in text box grouped within a trapezoid

Hi,

My macro fails when I try to have text within a textbox that is grouped with
a trapezoid (Autoshape). The text box is contained with the trapezoid.
What's driving me crazy is that I can update the text box manually when they
are grouped, but the macro fails when it tries to do the same thing. Is
there anyway to update the text box without ungrouping and then regrouping?
I want to avoid this because the group number incremements every time you
re-group and I remember reading that when an object number gets too large,
the macro will fail. Below is my code -- thanks in advance for your help!!

Sub updatewhengrouped()

ActiveSheet.Shapes("Text Box 7").Select
Selection.Characters.Text = "Always thought..."
Range("A1").Select

End Sub