Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Jan 2004
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Userforms (Excel 2003)

    I want to paste my excel chart from the spreadsheet on a userform/control, perferably on one of the tab/page control - (I'd like to have different charts on each tab/page). Is this possible?
    Also, can objects from drawing tool bar be pasted on the userforms?
    Also, can the text on a square textbox be centered vertically?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Userforms (Excel 2003)

    1) Userforms have no built-in support to display charts. There is a workaround, see Displaying a Chart in a UserForm. It requires you to create the chart in the workbook first, export it to a file, then display it on the userform. You could display different charts on different tab pages.

    2) In general, you could create a screenshot and place that in an image control.

    3) Not as far as I know

  3. #3
    New Lounger
    Join Date
    Jan 2004
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Userforms (Excel 2003)

    Thanks for the feedback,
    I wanted a chart that interacts with the user real time (as on a spreadsheet) as different data is entered.
    I'll stick to displaying them on the dialogsheet for now. I liked the userform idea because different interactive charts or matrices could be displayed on one form with mutipages, rather than using a separate dialogsheets for each chart.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Userforms (Excel 2003)

    I don't think you can have a chart on a userform that updates in real time.

  5. #5
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Userforms (Excel 2003)

    You can embed Office Web Components on userforms (using the Spreadsheet Control and Chart Control primarily). It would involve you copying the data from the worksheet, to the spreadsheet control, and then building the chart off that.
    HTH
    Regards,
    Rory

    Microsoft MVP - Excel

  6. #6
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Userforms (Excel 2003)

    Attached is a sample that may give you some ideas (it uses the XP web components - you may need to change the references).
    HTH
    Attached Files Attached Files
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

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