Excel chart display in a form

Hello,
I am just wondering how to display a excel chart into a form.
I was able to call my chart object in the VBA code as:

Dim temp As ChartObject

Set temp = Worksheets("ChartDisplay").ChartObjects(1)..

But should I be assigning that variable to an image to display on th
form? cuz going temp.visible doesnt work..


THanks

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

Hi Needhelp,

> I am just wondering how to display a excel chart into a form.
> I was able to call my chart object in the VBA code as:
>
> Dim temp As ChartObject
>
> Set temp = Worksheets("ChartDisplay").ChartObjects(1)..
>
> But should I be assigning that variable to an image to display on the
> form? cuz going temp.visible doesnt work..

It's not entirely straightforward <g>, but the pastepicture example on
my web site shows you how and John Walkenbach (www.j-walk.com) has
another method.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.co.uk