View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Insertion of Excel plots in a userform using VBA

There are a couple of methods:

http://www.j-walk.com/ss/excel/tips/tip66.htm
http://oaltd.co.uk/DLCount/DLCount.a...stePicture.zip

The first saves the picture as an image file, then loads the image into an
image control on the user form. The second bypasses the image file, instead
copying the chart, then extracting the image from the clipboard and putting
it into an image control. Neither is inherently dynamic, and you can't link
the image control to the chart, but you could use various event procedures
to keep the userform up to date.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"andredip" wrote in message
...
I would like to ask if someone know how to show a plot previously created
in
a sheet in a userform. It would be better if a link could exist, in order
to
allow automatic update.