+ Reply to Thread
Results 1 to 6 of 6

How to add new blank row and insert data in each cell using VBA user form

  1. #1
    Registered User
    Join Date
    03-11-2018
    Location
    Michigan,USA
    MS-Off Ver
    MS Office 2010
    Posts
    34

    How to add new blank row and insert data in each cell using VBA user form

    How to add new blank row and insert data in each cell using VBA user form.
    i have a spreadsheet with rows already populated. click of a button asks for where to insert blank row.as user specifies the row number . blank row is created and new user form pops up and user enters data and clicks submit button and these data should populate in the respective cells in the blank row

    Attached file

    If command button cliked . i type 12 and then the next form text box 1 value to populate in A12 and text box 2 B12
    Attached Files Attached Files
    Last edited by vinodhmmraj; 03-11-2018 at 11:54 AM.

  2. #2
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 365
    Posts
    8,080

    Re: How to add new blank row and insert data in each cell using VBA user form. - Urgent so

    It would be helpful if you could attach a copy of your file. This would make it easier to test possible solutions.
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

  3. #3
    Registered User
    Join Date
    03-11-2018
    Location
    Michigan,USA
    MS-Off Ver
    MS Office 2010
    Posts
    34

    Re: How to add new blank row and insert data in each cell using VBA user form

    Added the test file

  4. #4
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 365
    Posts
    8,080

    Re: How to add new blank row and insert data in each cell using VBA user form

    Try the attached file.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    03-11-2018
    Location
    Michigan,USA
    MS-Off Ver
    MS Office 2010
    Posts
    34

    Re: How to add new blank row and insert data in each cell using VBA user form

    It worked Great.. Thanks a lot will reply if any more questions. Mumps1.

  6. #6
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 365
    Posts
    8,080

    Re: How to add new blank row and insert data in each cell using VBA user form

    My pleasure.

+ 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] Insert Address data into the next row down from a user form.
    By Mark Dynes in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-15-2017, 08:42 AM
  2. User form to Search Data and Insert
    By magnum4u in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-23-2017, 11:16 AM
  3. Double click on cell > Open User form > insert value
    By amein in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-28-2016, 05:24 AM
  4. VBA to Insert row & data from user form in list
    By CajunAg in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-23-2013, 06:04 PM
  5. User form compile error - Need urgent help
    By Avinash1234 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-14-2013, 09:04 AM
  6. User Form - Insert Row then Data
    By cooper1308 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-04-2009, 08:38 PM
  7. User form to display adjacent cell value and move to next blank cell
    By Ketel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-21-2008, 03:15 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