+ Reply to Thread
Results 1 to 3 of 3

Userform Input data to Next blank Row for each data entry

  1. #1
    Registered User
    Join Date
    08-12-2020
    Location
    USA
    MS-Off Ver
    2016
    Posts
    18

    Userform Input data to Next blank Row for each data entry

    1597168415458.png

    were Textbox1 = Employee Number
    and Textbox2 = Line Chooses

    Please Login or Register  to view this content.
    when I type in 9324 in Textbox1 and 1.2.3 and textbox2 and press enter on the first set of data then type 6475 textbox1 and 10.9.8 in textbox2 and press enter for the second set of data The results I get with the above code is as follows:
    D E F G H I J
    9324 1 2 3 10 9 8
    6475

    What I need done is the second data of textbox2 to go with second data of textbox1 so results should be:
    D E F G H I J
    9324 1 2 3
    6475 10 9 8


    any help is greatly appreciated.
    Last edited by korekurd; 08-12-2020 at 05:43 PM.

  2. #2
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,523

    Re: Userform Input data to Next blank Row for each data entry

    Hi korekurd,

    Welcome to the forum!!

    As per Forum Rule # 3 "Questions that are cross-posted to other web forums must contain links to those posts on those forums or a comment to tell us where else the question has been asked."

    As this is your first post I have provided this link to the same question you posted on another forum. Please make sure you do so in the future.

    Regards,

    Robert
    ____________________________________________
    Please ensure you mark your thread as Solved once it is. Click here to see how
    If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post

  3. #3
    Registered User
    Join Date
    08-12-2020
    Location
    USA
    MS-Off Ver
    2016
    Posts
    18

    Re: Userform Input data to Next blank Row for each data entry

    thanks for the info. was not sure if I can post links to other websites.

+ 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. [SOLVED] Data Validation. Date Format in UserForm Data Entry
    By kmlloyd in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-09-2015, 11:12 PM
  2. Userform Data Entry (and editing previous data and generating report)
    By chubbyjenz in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-25-2014, 11:43 AM
  3. [SOLVED] Data Entry - Userform, override and update data instead of duplicate data.
    By mwinter in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-07-2014, 10:25 AM
  4. Data Entry - Userform, override and update data instead of duplicate data.
    By mwinter in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-06-2014, 05:31 AM
  5. Replies: 0
    Last Post: 02-04-2014, 12:36 AM
  6. [SOLVED] Userform only to input data to Sheet only if textbox contains data/number.
    By BPSJACK in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-31-2012, 11:30 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