Hello,

I have a chart in an MS Excel worksheet and I would like to change the
value/caption of a textbox( Text Box 20).

I have only been able to change the title of the chart with the
following:

With MyChart.Workbooks(1).Worksheets("Chart").ChartObje cts(1).Chart
.HasTitle = True
.ChartTitle.Text = "Summary of Report" & date() 'Add
Today's Date
End With

Do I have to reference the chart or do I have to reference the textbox
itself?