Results 1 to 2 of 2

Data Transfer: Userform to Worksheet

Threaded View

smartbuyer Data Transfer: Userform to... 11-24-2014, 05:24 AM
natefarm Re: Data Transfer: Userform... 11-24-2014, 01:15 PM
  1. #1
    Forum Contributor
    Join Date
    07-29-2013
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    110

    Data Transfer: Userform to Worksheet

    Hi,

    I am working on a Log (see attached: Call Log 2.0.xlsm) that will need to do the following:
    1. Enter new data on a new row when ANY of cell in row A:H is not empty.
    2. Multipage Page1 and Page2 details will be either or and will be entered in range A:D on next empty row.
    3. Clear userform after some or all textbox is filled in (via "Complete Log" CommandButton) without overwriting previously entered data.

    Problems:
    1. Next row code finds the next empty cell for each column. I need it to be entered in a new row when range A:H is not empty.
    NOTE: I have a time stamp on range H when textbox 4 and textbox 1 is typed on so it will always have details on it.

    Dim lastrow As Long
    Private Sub UserForm_Initialize()
      Dim i As Long, j As Long
      lastrow = 1
      For i = 1 To 9
          j = Sheets("Call Log").Cells(60000, i).End(xlUp).Offset(1, 0).Row
          If lastrow < j Then lastrow = j
      Next i
      
    End Sub
    2. Cant find code that allows userform to be cleared without deleting data from sheet.
    Last edited by smartbuyer; 11-24-2014 at 06:39 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Transfer Userform data on 1 worksheet to different worksheet (empty row = wrong sheet)
    By HeyInKy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-26-2014, 10:08 AM
  2. combining chart userform and data transfer userform into 1 userform
    By H_Kennedy in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-04-2014, 07:11 AM
  3. [SOLVED] Userform transfer data into worksheet
    By kheytli in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-30-2013, 01:09 PM
  4. Replies: 20
    Last Post: 05-24-2012, 10:51 AM
  5. Transfer Data From Userform to Worksheet
    By ScotyB in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-21-2012, 07:12 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