Results 1 to 10 of 10

User form data stored in sheet

Threaded View

  1. #1
    Registered User
    Join Date
    10-06-2016
    Location
    india
    MS-Off Ver
    2007
    Posts
    32

    User form data stored in sheet

    I have a form with some code to store the data in sheet, the code is
    Dim irow As Long
    Dim ws As Worksheet
    Set ws = Worksheets("Sheet1")
    irow = ws.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row
    With ws
    .Range("A" & irow) = TextBox1.Text
    .Range("B" & irow) = TextBox2.Text
    .Range("C" & irow) = TextBox3.Text
    .Range("D" & irow) = TextBox4.Text
    .Range("E" & irow) = TextBox5.Text
    End With
    here i can't able to insert the data in empty row in between the data, it will insert the data in last row only even if some rows are empty in middle. Please help me to clear this.

    Many thanks in advance

    br,
    COOL SAB
    Last edited by sabeelahmedks; 01-05-2018 at 01:57 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. User form link to data table at sheet
    By x_ampl1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-20-2014, 03:36 AM
  2. [SOLVED] send data from sheet to user form
    By msaric in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-19-2013, 08:51 PM
  3. [SOLVED] User prompted sheet name stored with quotations. I need them gone to be inputted into sub
    By grazian2 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-05-2013, 11:42 AM
  4. [SOLVED] To update stored records via user form
    By Shirly Percy in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-09-2012, 01:09 AM
  5. Using User Form to Select Data and Move to New Sheet
    By excelslizzard in forum Excel General
    Replies: 5
    Last Post: 05-09-2012, 02:18 PM
  6. Reading data from a user form into a sheet
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-16-2005, 05:05 PM
  7. [SOLVED] Adding data to sheet with user form
    By Jay in forum Excel General
    Replies: 1
    Last Post: 06-08-2005, 11:05 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