Results 1 to 6 of 6

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

Threaded View

  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.

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