![]() |
Loop through combo and copy graphs to Powerpoint
I use Excel (and Powerpoint) 2003. In Excel I have a sales graph object on a
worksheet (no chartsheet!), that represents the sales of one particular product family (in total there are 12 options like "shoes", "tennis rackets", etcetera). The selected combobox option is linked to a cell. That number is used again to select a specific range of data to show salesdata for the selected product family. Now I would like to loop through all options and after each display, copy the graph to Powerpoint. Any ideas how to set this up? Sub LoopGraphs_Copy2PP() Dim i as Integer For i = 0 to 11 'How do I loop through the combobox (it comes from Forms)? How do I loop through options? etcetera. |
All times are GMT +1. The time now is 08:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com