I have a project at work that did something like this (don't have access to
it now). I used Stephen Bullen's PastPicture.zip. It worked great.:
http://www.bmsltd.ie/Excel/Default.htm
I have the graph on a hidden worksheet and use the Multipage_Change event
(changing pages) to refresh the picture control. In my case, I only want the
graph to be visible in the UF so that's why I have it on a hidden worksheet.
My project only requires one graph. In your case it might be a bit too slow
to update all 14 at once. I suggest using the Tabstrip control so that only
one need update at once. I don't think there is a better way than
PastePicture.zip which interfaces through the cipboard instead of saving to a
file and importing (the latter being clunky). John Walkenbach has a method
similar to what you're trying to do. However, I found it's not even close to
the efficiency of PastePicture.zip. John's method:
http://j-walk.com/ss/excel/tips/tip66.htm
Regards,
Greg
"Alexis F" wrote:
Hi everyone!
I've got following problem which I need to solve asap:
I've been desperately trying to create a userform which includes a
multipage-control with charts (14 in all) and a "refresh" button to
update the charts (charts change as the calculations on the worksheets
change).
I've gotten this far:
1.) On clicking the refresh button,I can save the charts as .gif-files
in a subdirectory.
2.) When developing the userform I can then integrate the gif-files via
the property window.
.....but I can't figure out how I can reload the gif-files into the
pages of the multipage-control when the "refresh button" is clicked,
i.e. the form is running?
..... is there a better way of achieving this (or alternatively: of
showing multiple charts in a seperate window, in a organized fashion,
i.e. with Tab-strip et sim.)?
.....spent 2 loooooooong nights over this! AAARRRGGGHH!
thx,
Alexis
("VBA Beginner")
--
Alexis F
------------------------------------------------------------------------
Alexis F's Profile: http://www.excelforum.com/member.php...o&userid=25299
View this thread: http://www.excelforum.com/showthread...hreadid=387863