Dynamic chart title created in VBA does not auto-update

[DH112213]

Hi -
I have used the following code to create a dynamic chart title that gets its value from cell Sheet1!$A$1.

Please Login or Register  to view this content.

When the macro is run, the chart title initially displays what is in cell Sheet1!$A$1 correctly. However, I find that if the value in Sheet1!$A$1 changes, the chart title does not update.
If I manually link the chart title (select chart title and enter "=Sheet1!$A$1" into the formula bar) then the chart title updates appropriately when the cell value changes. When this is done using VBA, the chart title does not change when the linked cell value changes.

Thanks for your suggestions.

[Izandol]

If you are using 2010 you may use the Formula property:

Please Login or Register  to view this content.

[Andy Pope]

I had to change you code in order for it to compile and work

Please Login or Register  to view this content.

[DH112213]

Thanks. Yes - I checked that and found out what was happening.
There was a subsequent line the in the VBA that changed the chart font size.

Please Login or Register  to view this content.

When this line of code was executed, it changed the ChartTitle.Formula value to static text.

Reversing the order of these two commands resolved the issue. Now the chart title updates dynamically:

Please Login or Register  to view this content.