Question regarding Userform

[sinned141]

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?

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

 

[RoryA]

Yes - basically reverse all that in the Initialize event of the userform

Private Sub Userform_Initialize()

TextBox1.Text = Sheets("Details").Range("B12")
' etc
End Sub

 

[sinned141]

That's great

Thank you very much