Hello,

The following code will only store the last [Textbox4.value].
Is there a way to save them below each other, but without using "LastRow + 1"?


[VBA]
Sheets("1").Range("B" & LastRow).Value = UserForm1.TextBox2.Value
Sheets("1").Range("B" & LastRow).Value = UserForm1.TextBox3.Value
Sheets("1").Range("B" & LastRow).Value = UserForm1.TextBox4.Value
[/VBA]