+ Reply to Thread
Results 1 to 5 of 5

Pasting Data from non-excel table into userform

  1. #1
    Registered User
    Join Date
    12-02-2015
    Location
    Peterborough, England
    MS-Off Ver
    2007
    Posts
    19

    Pasting Data from non-excel table into userform

    Hi All,

    I've got one of my guys doing some mass data entry for a project and part of the process is filling out a fairly large userform. Part of the data capture involves pasting 20 or so values from a non-excel table into a userform (and he's currently doing it line by line which is painful).

    The data is in two columns, 10 or so rows long and all rows are relevant, is there anyway of setting up the userform to allow the data to be pasted 'as-is', automatically populating a series of text boxes to match the source formatting or via some other user-form based method?

    Example data to paste to userform:
    Attached Images Attached Images

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

    Re: Pasting Data from non-excel table into userform

    Where does the data come from?
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    12-02-2015
    Location
    Peterborough, England
    MS-Off Ver
    2007
    Posts
    19
    Quote Originally Posted by Norie View Post
    Where does the data come from?
    The user is copying it from a table on a web-based application.

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

    Re: Pasting Data from non-excel table into userform

    I don't think this is going to be possible.

    You can paste directly into a textbox but not into multiple controls.

    I suppose, if it was possible to parse the data, it could be pasted into a (multiline?) textbox and then separated out as required.

    The only other thing I can think of would be to save the data to a file and read it from there.

  5. #5
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Re: Pasting Data from non-excel table into userform


    Hi,

    or directly use a web request to read source data. Many samples in threads of this forum …

+ 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. Pasting Table Data Into Excel Not Working
    By thegoof in forum Excel General
    Replies: 3
    Last Post: 10-15-2017, 09:16 PM
  2. Pasting data from excel to userform
    By VaibhavAr in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-01-2016, 01:12 AM
  3. [SOLVED] Error pasting data (including headings) into an excel table when heading is variable
    By L plates in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-10-2016, 01:20 PM
  4. Pasting Excel data to Word table via Range.PasteAppendTable
    By Karlosus in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 08-10-2015, 03:34 AM
  5. Replies: 5
    Last Post: 10-10-2014, 12:44 PM
  6. Creating table in microsoft word from excel and pasting data
    By aserle in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-29-2013, 03:47 AM
  7. Userform getting data from Excel table
    By Freaky_zoid in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-15-2009, 01:55 AM

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