ExcelBanter - Graph in form

Omar,

Not as far as I know directly. The usual approach is to paste a picture of
the graph onto the form by exporting the graph from a sheet or chart sheet
as an image then loading the image from disk to a picture box. There's a
faster alternative using Stephen Bullen's PastePicture routine which avoids
having to save to disk but it is quite a complex piece of code. The chart
browser in my XspandXL add-in on my site uses the latter for speed reasons.

I have not done this before, but if you really really want to achieve this,
you could try to embed an Office Web Component Chart Control on the form.
You'll need it installed and so would all your target machines, of course,
then you'll have to figure out the object model. I've just tried it to see
how it looks and it is possible to get it on the form. In the VBE, open the
toolbox, right click and select Additional Controls, then look for Microsoft
Office Chart n.nn to find the control, then draw it on your form. From
there, you are on your own as far as figuring it out I'm afraid. In the few
minutes I have I haven't tried to set it up to hook to Excel directly for
its data.

Robin Hammond
www.enhanceddatasystems.com

"Omar" wrote in message
...
Hi,

I'd like to know if it's possible to add (I mean, to calculate and show)
an
Excel graph in a VBA form. I wouldn't like to import the graph as an
image.

I've searched some class information in the VBA editor, but I haven't
found
any.

Could you point me in the right direction?

TIA.