Insertion of Excel plots in a userform using VBA

[andredip]

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.

 

[Jon Peltier]

There are a couple of methods:

http://www.j-walk.com/ss/excel/tips/tip66.htm

 

[Jon Peltier]

There are a couple of methods:

http://www.j-walk.com/ss/excel/tips/tip66.htm
http://oaltd.co.uk/DLCount/DLCount.asp?file=PastePicture.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