I have a little problem.
I have a userform with some textboxes .I want something like these:
When I write in first textbox, I want to write in cells A50 and B50 in Sheet 1 and in C25 and D25 in Sheet 2
When I write in second textbox, I want to write in cells H33, H34, H35 and H36 in Sheet 1 and I10, J12, H13 in Sheet 2
And so on
At last I have 2 buttons: one for aprove (OK) and another for cancel (Cancel). Also I want to put macros for each one.
I find something but it's doesn't work for all Textboxes; only first :

(
Sheets("Sheet1").Select
Sheets("Sheet1").Range("A50").Value = UserForm2.TextBox1.Text
Sheets("Sheet2").Select
Sheets("Sheet2").Range("C25").Value = UserForm2.TextBox1.Text
)

Maybe instruction "with" could be another idea but if you have other ideas pls tell me
Thank you.