Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 335
  • Last Modified:

VBA Chart Object Probably Simple!!??

Hi Folks,

I am currently writing one of my first VBA applications which is used to display different Charts. The source data for the charts is contained in a worksheet. I would like to be able to display the charts on a Userform but don't know how to!!

I have tried placing it in Frames, Image Boxes and Chart area object using the following code, but this does not work! ...

ActiveChart.Location Where:=xlLocationAsObject, _ Name:=FrmGraph.ChtGraphArea

Is there a way to display charts in Userforms? Please help. Thanks
0
craigpike
Asked:
craigpike
1 Solution
 
GrahamSkanRetiredCommented:
You should add a chart component, e.g. Microsoft Chart Control, to the Forms toolbox (via Tools/Additional Controls).
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now