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.
Bookmarks