this is my first post on here. I'm searching for a code that add the textboxes from a userbox in another sheet but just different rows. I can find the most on the internet and quite understand it, but this one I find hard to solve.
The codes I already have for adding data in the last row is a the following (the text is Dutch, I'm sorry for that)
Private Sub Cmdbutton_add_Click() WsOne = Blad6.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row Cells(WsOne, 1).Value = SKUadd.Text Cells(WsOne, 2).Value = Naamadd.Text Cells(WsOne, 3).Value = Productomadd.Text Cells(WsOne, 4).Value = Productcatadd.Text End sub
Now I want "SKUadd" and "Naamadd" to be in another sheet that is called "Voorraden" or "Blad3" at the first two rows. And I want "Productcatadd" in that same sheet but at the 5th column.
Could anyone help me with this problem? I would like to hear from you guys
p.s. I'm a complete newbie lol