1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
| With ActiveSheet.ChartObjects("chart_eff").chart.Shapes.AddTextbox(msoTextOrientationHorizontal, _
left_blank_2, top_blank_2, width_blank_2, heigth_blank_2)
.Fill.Visible = msoTrue
.Fill.Solid
.Fill.ForeColor.SchemeColor = 1 ' white
With .TextFrame
With .Characters(Start:=1, Length:=55).Font
.Name = "Arial"
.FontStyle = "Regular"
.Size = 10
.Strikethrough = False
.Superscript = False
.Subscript = False
.ColorIndex = 2 ' white
End With
.Characters.Text = "CELA NE MARCHE PAS" ' Allowable operating region
End With
End With |
Partager