Excel VBA- copy data from userform to sheet 1 with a new row each time

[PANTECH]

I have very limited experieince with Excel VBA. Please tell me how to write code to take data entered into Userform Inventory and place it into Sheet 1 on a new row each time after the record has been saved.

txtMaterial starts on column A2
txtBin starts on column B2
txtIssued starts on column C2
txtReceived starts on column D2
cboDepartment starts on column F2
txtRecipient starts on column G2
txtFaics starts on column H2
cboInitials starts on column I2

Please Login or Register  to view this content.

[tehneXus]

Hi,

Please Login or Register  to view this content.

Regards

[PANTECH]

What did I do wrong? The record went to line 326, the first available line was line 2.

Please Login or Register  to view this content.

[tehneXus]

Hi,

most probably because your worksheet contains empty ending blank cells where the contents were removed instead of entire rows.
Remove those rows or use:

Please Login or Register  to view this content.

instead of

Please Login or Register  to view this content.

Regards