ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Loop through combo and copy graphs to Powerpoint (https://www.excelbanter.com/excel-programming/341814-loop-through-combo-copy-graphs-powerpoint.html)

Martin Los[_3_]

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