+ Reply to Thread
Results 1 to 3 of 3

Display table contents in a userform

  1. #1
    Registered User
    Join Date
    11-18-2016
    Location
    Windhoek, Namibia
    MS-Off Ver
    Excel2013
    Posts
    10

    Display table contents in a userform

    Hello!

    I have some data on a table("FSTHR_tests") in the worksheet ("Project Results") and want to extract some of the data to make some graphs, which will be diplayed in UserForm1. Below is my attempt to the code. I get the error: 'Method 'Values" of object "Series" failed. Any assistance would be greatly appreciated!

    Please Login or Register  to view this content.
    Please note that the case is not done yet. There will be many more graphs to follow. I only want to get my code working for one graph. Further, The error is on the line
    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: Display table contents in a userform

    Is Avg_Burn_Time a variable or is that the name you want for the chart? If the latter then it needs to be in quotes.
    Please Login or Register  to view this content.
    If someone has helped you then please add to their Reputation

  3. #3
    Registered User
    Join Date
    11-18-2016
    Location
    Windhoek, Namibia
    MS-Off Ver
    Excel2013
    Posts
    10

    Re: Display table contents in a userform

    I have solved this with the help of Tsjallie. He is advising on this forum as well.here is the core part the code to display table contents in your userform:

    Please Login or Register  to view this content.
    If any help is needed please feel free to reply to this thread.

+ 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. Display table contents in a userform
    By PNam in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 11-28-2016, 11:38 AM
  2. Replies: 1
    Last Post: 11-21-2016, 04:24 PM
  3. How to display dashboard\Table in userform
    By Pranuvins in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-27-2016, 03:03 AM
  4. Userform Syntax to have textbox display Msgbox when contents left unchanged
    By clemsoncooz in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-01-2012, 06:25 AM
  5. Display Contents Of (Multiple Items) From Pivot Table
    By sqledge in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-30-2010, 12:50 PM
  6. excel cell to display footer (table of contents)
    By hamsuplo in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-09-2010, 09:00 PM
  7. Display contents of (Multiple Items) from Pivot Table
    By Pasha in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-12-2005, 08:05 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