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.

There are a couple of methods:

http://www.j-walk.com/ss/excel/tips/tip66.htm
"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.

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.