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.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.