Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

VBA Chart Object Probably Simple!!??

Posted on 2003-12-01
4
Medium Priority
?
333 Views
Last Modified: 2013-11-13
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
Comment
Question by:craigpike
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 76

Accepted Solution

by:
GrahamSkan earned 300 total points
ID: 9858485
You should add a chart component, e.g. Microsoft Chart Control, to the Forms toolbox (via Tools/Additional Controls).
0

Featured Post

What’s Wrong with Your Cloud Strategy ?

Even as many CIOs are embracing a cloud-first strategy, the reality is that moving to the cloud is a lengthy process and the end-state is likely to be a blend of multiple clouds—public and private. Learn why multicloud solutions matter in this webinar by Nimble Storage.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this post we will learn how to make Android Gesture Tutorial and give different functionality whenever a user Touch or Scroll android screen.
Make the most of your online learning experience.
An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …
Progress

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question