I am automating Excel with Delphi 7.0.
How do I insert a formula into a textbox?

With VBA I would do: (with the textbox on a chart)

ActiveChart.Shapes("Text Box 1").Formula = "Sheet1!$A$1"

but I can not get anything like this to work in Delphi

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com