+ Reply to Thread
Results 1 to 8 of 8

Userform not running for charts

  1. #1
    Registered User
    Join Date
    07-13-2010
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    21

    Userform not running for charts

    Hi,

    I am attaching the excel on which i need help.
    I want to insert charts in the Userform5 based on the combobox option on the same userform.

    I have gone through many forums and have copied the formula and tried my level best to display the charts.

    The problem:-
    The charts are getting displayed properly when i run the userform directly from the code window.

    But as soon as i run it from the worksheet "master" using command button "Reports" the charts dont get displayed properly.

    Request you to please help.

    Regards,

    Udit
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    07-13-2010
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    21

    Re: Userform not running for charts

    Guys Please help....

  3. #3
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Userform not running for charts

    The charts display fine when I try it.

    The only problem is that there are only 6 charts and when you select Partner Share the code tries to refer to a 7th chart.
    If posting code please use code tags, see here.

  4. #4
    Registered User
    Join Date
    07-13-2010
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    21

    Re: Userform not running for charts

    Hi Norie,

    I am attaching a screenshot of the problem im facing when i runf the userform from the command button reports.
    When I change the combobox to packing the charts does not show. When i select paints the whole size of the charts distorts (screenshot attached as excel file)

    But the userform runs perfectly when i run it from the VBA window.

    I dont know what is happening and how.

    Request your help in getting it streamlined.
    Attached Files Attached Files

  5. #5
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Userform not running for charts

    This is what I see when I select Paints.
    Attached Images Attached Images

  6. #6
    Registered User
    Join Date
    07-13-2010
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    21

    Re: Userform not running for charts

    this is so strange. are you running the userform from the command button called reports on the worksheet "master" or are you running it from the vba window?
    As i am facing the problem when the userfom is loaded using the command button.

    regards,

    udit

  7. #7
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Userform not running for charts

    I'm running from the command button.

  8. #8
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: Userform not running for charts

    I had to use xl2007 in order to recreate the problem.

    add code to userform initialize event.
    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

+ 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. Conditional Running Totals with Pivot Charts
    By tfortier in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-30-2013, 01:56 AM
  2. UserForm not running
    By jstoler in forum Word Programming / VBA / Macros
    Replies: 1
    Last Post: 05-05-2013, 02:18 AM
  3. Charts in userform
    By Mortada in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-23-2013, 06:50 PM
  4. [SOLVED] Running GIF in userform
    By Graham Whitehead in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-07-2006, 12:15 PM
  5. [SOLVED] Running GIF in userform
    By Graham Whitehead in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-07-2006, 12:10 PM

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