Solved: Format trend line dialog box

[Not So Smart]

I am trying to get the format trend line dialog box that is built into the Excel Charting features to open by a macro command.

The clipboard window will open by macro cammand. Does anyone know how to do this or if it cannot be done.

Thanks

Not So Smart

[Andy Pope]

In xl2003, assuming trendline is selected.

[vba]
application.CommandBars.FindControl(ID:=917).Execute
[/vba]

[Not So Smart]

Thanks Andy

I just ran accross some code that works in the V2007

ActiveChart.SeriesCollection(1).Select 'the data points must be selected for the dialog box to open.
Application.Dialogs(xlDialogChartTrend).Show

I am in good shape now & want to post this to others who may need it.

[Andy Pope]

Okay but those display 2 different dialogs.
Notice the Patterns tab is not available with that built-in dialog.