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.

Please Login or Register  to view this content.

2. Cant find code that allows userform to be cleared without deleting data from sheet.

1. If there are no "empty" rows after your data rows, the following will work:

Please Login or Register  to view this content.

To eliminate empty rows, on your worksheet, hit Ctrl+End. It will put you in the lower-right cell where it thinks there's data (the same as SpecialCells(xlLastCell)). Delete any blank rows (above and including the last row) and columns. You must save the workbook for the deletions to go into effect. Then try Ctrl+End again to verify.

2. The If statements you have in your textbox Change events should bypass updating the worksheet when you clear the textbox value (the text length would be 0), so when is it clearing the data?