November 27th, 2002, 8:50 pm
Domingues,I assume you are trying to place an Excel chart onto a VBA UserForm (?).Unfortunately it cannot be done directly. The easiest way would be to convert the Excel chart to a bitmap and then to assign the bitmap to the .Picture property of the form itself (i.e. as a background bitmap) or the .Picture property of an Image control.Of course an alternative is to plot your chart programmatically. You would have to do this by making calls to the Win32 (GDI) API, as none of the built-in VBA controls have the VB drawing methods (Pset() etc. )Using a 3rd party charting control (e.g. ChartFX, Dundas Chart) is another option if you have access to one.Let me know if you need more help.P.