+ Reply to Thread
Results 1 to 9 of 9

Chart in Userform

  1. #1
    Registered User
    Join Date
    06-19-2013
    Location
    Sheffield
    MS-Off Ver
    Excel 2013
    Posts
    86

    Chart in Userform

    Hello,

    I would like to insert a chart in a userform. The coding part shouldn't be too difficult but I should add "Microsoft Office Spreadsheet 9.0" and "Microsoft Office Chart 9.0" in the Toolbox. I searched them right-clicking on Toolbox and selecting "Additional Controls". They are not in the list. How can I add them?

    Thank you

  2. #2
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,138

    Re: Chart in Userform

    Here's an article about that.
    David
    (*) Reputation points appreciated.

  3. #3
    Registered User
    Join Date
    06-19-2013
    Location
    Sheffield
    MS-Off Ver
    Excel 2013
    Posts
    86

    Re: Chart in Userform

    I already saw it. But this means using saving the chart as an image and then use it. I would like to built the chart through coding and then show it through directly in the user form. As you can see here (http://www.vbaexpress.com/forum/showthread.php?t=7760) it is possible to do it but I cannot add the Additional Controls to the Userform Toolbox..

  4. #4
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,138

    Re: Chart in Userform

    Are you running the 64-bit version of Windows? Apparently the controls are not available in that version.

  5. #5
    Registered User
    Join Date
    06-19-2013
    Location
    Sheffield
    MS-Off Ver
    Excel 2013
    Posts
    86

    Re: Chart in Userform

    Just formatted the laptop installing Windows 64-bit and Excel 2013 hoping for improvements.....
    Thank you

  6. #6
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Chart in Userform

    the owc library is not part of a standard office instal since 2007 but you can download the library from microsoft
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  7. #7
    Registered User
    Join Date
    06-19-2013
    Location
    Sheffield
    MS-Off Ver
    Excel 2013
    Posts
    86

    Re: Chart in Userform

    A clue about where to find them?
    Thanks!

  8. #8
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,138

    Re: Chart in Userform

    According to this thread, there doesn't seem to be a solution.

  9. #9
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Chart in Userform

    that only applies to 64bit Office, not 64bit windows

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. creating a chart from a userform
    By shakey775 in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 01-03-2012, 08:15 AM
  2. Resolved >>> Placing a chart on a userform
    By toocold in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-24-2007, 08:37 PM
  3. Print Chart from UserForm
    By Herve_Rob in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-21-2007, 09:07 AM
  4. Chart on a Userform
    By Rocky McKinley in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-12-2005, 11:05 AM
  5. how to insert a chart in a userform?
    By Christoph Strobelt [Bt] in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-06-2005, 09:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1