Displaying Chart on Userform (with Scroll Bars)
Put the image control on a frame. Set frame's Scrollbars to both and set
scroll height & width to suit. These can be changed at run time to adjust to
a newly loaded picture size if say you set the image control's autosize to
true.
Concerning image quality, particularly when scaled, try a wmf instead of
gif.
Regards,
Peter T
"wanderlust" wrote in message
oups.com...
Hi,
I have a userform which displays a chart. I used a workaround (on
John Walkenbach's Site) whereby, I save the Graph as a Gif image and
paste it onto the userform.
I have an image placeholder on the userform that accesses the GIF
file. The problem that I have is that when I display the Chart, I would
like to have scrollbars so that the user can move around when the chart
is larger than the image placeholder on the userform.
I tried to zoom the chart to fit in the image placeholder, but it
seems to distort the chart and I can't read the numbers very clear. Is
there any way I can add Scrollbars to the image placeholder on the
userform or is there any other method to do this.
Thanks,
Ravi
|