+ Reply to Thread
Results 1 to 7 of 7

User form to add data in next row in column range

  1. #1
    Registered User
    Join Date
    11-12-2013
    Location
    Stockholm, Sweden
    MS-Off Ver
    Excel 2013
    Posts
    5

    User form to add data in next row in column range

    I need help to figure out how to get my user form to put in the data inserted under the next empty row in specified columns. I have data in column A and B (for other formulas and lookups) but need data to be updated in column C, D, F, G, I, J, L, M .. the other columns have data in them and are not in need for update. I can't for the life of me find the right code to get the next empty row with data when user form is used. Appreciate help and suggestions on how to solve this. Thanks!

  2. #2
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: User form to add data in next row in column range

    Perhaps if you attached a workbook with a before an after example it may make what you would like a little more clear.

    To attach a workbook click the 'Go Advanced' button below, then the paperclip in the toolbar. This will bring up a browser to navigate to your sample file.
    Thanks,
    Solus


    Please remember the following:

    1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    Highlight the code in your post and press the # button in the toolbar.
    2. Show appreciation to those who have helped you by clicking below their posts.
    3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

    "Slow is smooth, smooth is fast."

  3. #3
    Registered User
    Join Date
    11-12-2013
    Location
    Stockholm, Sweden
    MS-Off Ver
    Excel 2013
    Posts
    5

    Re: User form to add data in next row in column range

    Here is an example of the document.

    The white columns is where the data need to be put into with help of a userform instead of having them mess with the actual columns and documents. It would be awesome if you could help me with this.

    ExampleFile.xlsm

  4. #4
    Registered User
    Join Date
    11-12-2013
    Location
    Stockholm, Sweden
    MS-Off Ver
    Excel 2013
    Posts
    5

    Re: User form to add data in next row in column range

    To clarify, I don't need help building the form that is already done. I just need help to figure out how it can find the empty rows in the columns that I want the data put into. I just don't want you all to think you have to "build the form for me", just some guidance with the macro and VBA.

  5. #5
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: User form to add data in next row in column range


  6. #6
    Registered User
    Join Date
    11-12-2013
    Location
    Stockholm, Sweden
    MS-Off Ver
    Excel 2013
    Posts
    5

    Re: User form to add data in next row in column range

    Ooooh, works like a charm! Thank you so so much

  7. #7
    Registered User
    Join Date
    11-12-2013
    Location
    Stockholm, Sweden
    MS-Off Ver
    Excel 2013
    Posts
    5

    Re: User form to add data in next row in column range

    Ok, no, nevermind .. it doesn't work at all now. worked fine yesterday but today when I opened the file it doesn't work anymore. What to do?

+ 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] User forms - choosing location of your data to be shown in your user form
    By jasonbwt in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-29-2012, 08:48 AM
  2. Code to select range and open a user form is opening the wrong range
    By rrbest in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-05-2010, 12:34 PM
  3. User Form, how to Save and Add Data to Range
    By Patchworks in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-15-2009, 04:22 AM
  4. user form - data range
    By sam1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-27-2006, 08:30 PM
  5. [SOLVED] How to: User Form to assign a user defined range to a macro variab
    By TrevTrav in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-22-2005, 04:06 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