+ Reply to Thread
Results 1 to 3 of 3

?How to Write New Input (from userform) to top (row1) each time?

  1. #1
    Registered User
    Join Date
    04-22-2013
    Location
    Baton Rouge, LA
    MS-Off Ver
    Excel 2010
    Posts
    20

    ?How to Write New Input (from userform) to top (row1) each time?

    Hi guys

    Is there a way to have my new entries written to row2 instead of the last empty row?
    (sorry for the tittle errow- row1 has the column names, so the data would have to start at row2)
    I am guessing it would have to insert a row above row2 to push the existing data down and write to the newly inserted top row.
    I have a userform that collects the data and writes to the last empty row, but I guess it will be easier for the users to see the newest entries on top when excel opens since the list of entries is sooo long and will become very long as years go by.

    This is my userform NextButton code that transfers the userform data onto the excel sheet.

    HTML Code: 
    Thanks in advance for all of your help!
    Last edited by ReedDOT; 06-07-2013 at 08:55 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: ?How to Write New Input (from userform) to top (row1) each time?

    Please Login or Register  to view this content.
    Hope this helps

    Sometimes its best to start at the beginning and learn VBA & Excel.

    Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
    Available for remote consultancy work PM me

  3. #3
    Registered User
    Join Date
    04-22-2013
    Location
    Baton Rouge, LA
    MS-Off Ver
    Excel 2010
    Posts
    20

    Re: ?How to Write New Input (from userform) to top (row1) each time?

    Awesome!
    Thanks a bunch!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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