G Graphically Challenged Aug 7, 2009 #1 If I select the banner autoshape, how do I get the text to follow the curves of the banner when I add text to the shape?
If I select the banner autoshape, how do I get the text to follow the curves of the banner when I add text to the shape?
H Héctor Miguel Aug 8, 2009 #2 hi (...), ????? If I select the banner autoshape, how do I get the text to follow the curves of the banner when I add text to the shape? Click to expand... how about embedding a WordArt object and use the '_change' event on that worksheet code module ? (i.e.) Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$A$1" Then Me.Shapes("wordart 1").TextEffect.Text = [a1].Text End If End Sub hth, hector.
hi (...), ????? If I select the banner autoshape, how do I get the text to follow the curves of the banner when I add text to the shape? Click to expand... how about embedding a WordArt object and use the '_change' event on that worksheet code module ? (i.e.) Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$A$1" Then Me.Shapes("wordart 1").TextEffect.Text = [a1].Text End If End Sub hth, hector.
H Héctor Miguel Aug 9, 2009 #3 hi, again (...), ????? here is anther alternate: http://spreadsheetpage.com/index.php/tip/rotating_text_with_an_autoshape/ regards, hector.
hi, again (...), ????? here is anther alternate: http://spreadsheetpage.com/index.php/tip/rotating_text_with_an_autoshape/ regards, hector.
