Excel chart display in a form

  • Thread starter Thread starter needhelp
  • Start date Start date
N

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
 
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..
Click to expand...

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
 
Back
Top