Hi All
I have a userform with several textboxes which fill on my worksheet when I press the fill button, however I was wandering if there is a way I can change this so that I can open the userform to edit the text rather than having to rewrite it all?
Many Thanks in advance
I have a userform with several textboxes which fill on my worksheet when I press the fill button, however I was wandering if there is a way I can change this so that I can open the userform to edit the text rather than having to rewrite it all?
Code:
Private Sub CommandButton1_Click()
Sheets("Details").Range("B12") = TextBox1.Text
Sheets("Details").Range("B15") = Textbox2.Text
Sheets("Details").Range("B13") = TextBox3.Text
Sheets("Details").Range("B16") = TextBox4.Text
Sheets("Details").Range("B17") = TextBox5.Text
Sheets("Details").Range("B19") = TextBox6.Text
Sheets("Details").Range("B20") = TextBox7.Text
Sheets("Details").Range("B14") = TextBox8.Text
Sheets("Details").Range("B18") = TextBox9.Text
End Sub
Many Thanks in advance