I have code that worked in excel 2003, but errors in 2007

[dogelsby]

I am creating several charts and adding labels to them. The charts on one page of a work book and the data and labels are on another

With NewChart.TextBoxes.Add(1, 1, 234, 15)
End With
NewChart.DrawingObjects ("Text 1").HorizontalAlighnment = xlCenter
New Chart.DrawingObjects ("Text1). Formula ="'[" & StandardXLC.Name & "]" & StdData.Name & "'!$A$" & Std row


the error says that the item with the specified name wasn't found. Text 1 is defined as a text box

the code worked fine in the older version of excel, but when I try to run it in 2007 I get the error.

I am not a programmer, just trying to maintain code written by someone else

thanks for help

[Norie]

Are you sure the name of the textbox is 'Text 1'?

Does this work?

Please Login or Register  to view this content.

PS Can you add code tags when posting code?

[dogelsby]

That did work, thank you. It then generated a new error : "Unable to set Formula Property of the textbox class"