PDA

View Full Version : Solved: Format trend line dialog box



Not So Smart
06-25-2008, 04:03 PM
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
06-26-2008, 07:07 AM
In xl2003, assuming trendline is selected.


application.CommandBars.FindControl(ID:=917).Execute

Not So Smart
06-26-2008, 07:12 AM
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
06-26-2008, 07:18 AM
Okay but those display 2 different dialogs.
Notice the Patterns tab is not available with that built-in dialog.