(Solved) – I have 4 values obtained from a form, I would like to paste these values into a worksheet

  • by

I have these four values obtained from a userform.

With Worksheets("Sheet1)

TextBox1.Value = Worksheets("Sheet1").Range("A2")
ListBox1.Value = Worksheets("Sheet1").Range("B2")
TextBox2.Value = Worksheets("Sheet1").Range("C2")
ListBox2.Value = Worksheets("Sheet1").Range("D2")

End with

But I want to paste in the next available row instead of just replacing the data in row 2. How can I make it dynamic like that? Do I need to count the number of items already there? So if the user opens the form again, the previously entered data is still there and we just add on. Also, how could I put the current date as the default value in TextBox1?

Leave a Reply

Your email address will not be published. Required fields are marked *