select any chart in worksheet

[louay]

is there any way to select chart via name

using vba code in excel

 

[louay]

always give me

MsgBox "A chart named '" & ChartName & "' does not exist, please try again!"




in general the all idea i want is ​

select chart already saved in excel and change the title of it

 

[louay]

always give me


ChartName & "' does not exist, please try again!</pre>

 

[Domenic]

Have you checked to make sure that the name you enter in the InputBox is exactly the same as the name of the chart? So there should be no spelling mistakes, extra spaces, etc.

 

[louay]

i am very sure

but if i make it in simple code like
activeSheet.Charts(InputBox("Chart name?")).ChartTitle.Text = "chart title"

but don't work also

 

[Domenic]

i am very sure

Does the solution offered by Shg work for you?

but if i make it in simple code like
activeSheet.Charts(InputBox("Chart name?")).ChartTitle.Text = "chart title"

but don't work also

Try...

[COLOR=#333333]ActiveSheet.[/COLOR][COLOR=#ff0000]ChartObjects[/COLOR][COLOR=#333333](InputBox("Chart name?")).[/COLOR][COLOR=#ff0000]Chart[/COLOR][COLOR=#333333].ChartTitle.Text = "chart title"[/COLOR]