Excel chart display in a form

[needhelp]

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

 

[Stephen Bullen]

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