+ Reply to Thread
Results 1 to 6 of 6

Possible to transfer data from userform into excel table???

  1. #1
    Registered User
    Join Date
    07-09-2017
    Location
    United Kingdom
    MS-Off Ver
    2010
    Posts
    39

    Possible to transfer data from userform into excel table???

    Hi, I have created a example excel workbook to add data to the worksheet.


    I have set the range so the data will be transferred into Table1.



    However the data doesn't get transferred into the first row of Table1.



    Any possible solutions around this, if so how can it be applied?



    I have attached below my workbook for reference.



    Many thanks!

    Kind regards,

    Kamal1234
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    07-23-2016
    Location
    Texas
    MS-Off Ver
    2016
    Posts
    269

    Re: Possible to transfer data from userform into excel table???

    Not sure what you want to do. You copy the text from the form into "Cells (LastRow,1), etc. If you want it in the first row of the table, can't you just specify "Cell(2,1), etc. Your question isn't clear.

  3. #3
    Registered User
    Join Date
    07-09-2017
    Location
    United Kingdom
    MS-Off Ver
    2010
    Posts
    39

    Re: Possible to transfer data from userform into excel table???

    DataEntryFrm works but Row A2 is left blank when data entry is formed. Any ways to get data transferred From first row A2 instead of leaving it blank.

  4. #4
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Possible to transfer data from userform into excel table???

    Hi Kamal1234

    Try this Code...
    Please Login or Register  to view this content.
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  5. #5
    Registered User
    Join Date
    07-09-2017
    Location
    United Kingdom
    MS-Off Ver
    2010
    Posts
    39

    Re: Possible to transfer data from userform into excel table???

    jaslake, many thanks for your help and time!!! The thread is now marked as solved! Thank you for resolving my problem,

    May I confirm if this code can be used on multiple worksheets that contain different excel tables?

    Many thanks once again!!!

    Kind regards,

    Kamal1234
    Last edited by Kamal1234; 02-02-2018 at 07:36 PM.

  6. #6
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Possible to transfer data from userform into excel table???

    Hi Kamal

    May I confirm if this code can be used on multiple worksheets that contain different excel tables?
    In general, yes...if you have only one Table on the Worksheet and Column 1 (A) is the appropriate Column in which to find "R" (the last row).

    You're welcome...glad I could help. Thanks for the Rep.

+ 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. Transfer userform data to excel sheet
    By markusvirus in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-06-2017, 05:11 AM
  2. [SOLVED] Transfer Data from Userform to Worksheet Table
    By How How in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 01-10-2017, 04:02 PM
  3. combining chart userform and data transfer userform into 1 userform
    By H_Kennedy in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-04-2014, 07:11 AM
  4. combining chart userform and data transfer userform into 1 userform
    By H_Kennedy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-03-2014, 12:28 PM
  5. Excel UserForm Transfer of data to Columns
    By rudevincy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-20-2012, 12:43 AM
  6. UserForm to transfer items from one table to another table in the next empty cell...
    By aneese11 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-04-2012, 10:31 AM
  7. VBA to transfer Excel data to an Access table
    By beckajayne in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-18-2011, 03:00 PM

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