chart or graph on VBA userform

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

Thanks Peter,

May go for this as a last resort... no offence

I was hoping to do it "literally" not by creating and pasting a GIF onto the form

Mike

Before you dismiss the suggestion out of hand, try it. You may not notice the difference between a quickly changing image and a live chart.

You don't have to copy and paste the chart, either. It is exported as a gif file, which the image control is linked to.

Thank you Jon.
Peter - apologies if I was somewhat hasty in dismissing the idea.

The problem is that the workbook will hold personal data of up to 43 people at each site, with different access and view "rights" controlled by a vba / password log in form.

Creating a gif of a chart of an individual creates it on the computer system as a stand-alone graphic, which would normally get left in existance after excel has been closed.
Thinking about it now, if I create the GIF when chart is updated, place it into the form, and kill the GIF via VBA when the form gets shut down, that should, hopefully, solve that problem. With luck, the end user will never realise the GIF exists int he first place

thanks for your replies guys, got me thinking more. again, apologies if I seemed ungrateful

Mike

A more complicated alternative that negates the privacy issue is to use Stephen Bullen's PastePicture approach: copy the chart as a picture, then use his routine to place the image into the form.

The example is about 2/3 of the way down this page:

http://www.oaltd.co.uk/Excel/SBXLPage.asp