userform

[buckshot]

Hello
I have an invoice spreadsheet with a command button that pops up the user form that has about 8 text boxes on it that I enter invoice information that transfers to various cells in my invoice spreadsheet.I can not seem to get information to stay in textbox after it is closed and opened again.Is there a way that I could put another text box beside the original to show what is actually entered these cells from the spreadsheet.Thanks in advance.

[BigBas]

Can you post the code that you are currently using with the CommandButton click event? Also, you want the last information that was entered to stay in the textbox even after it has been populated to the worksheet?

[buckshot]

This is the command button code that takes me to user form.

Sub Button12_Click()
UserForm2.Show
End Sub

This is the code for the text box

Private Sub TextBox1_Change()
ActiveSheet.Unprotect Password:=""
Range("V58,Q10").Value = TextBox1.Value
ActiveSheet.Protect Password:=""
End Sub

Yes I would like the last bit of information to remain in text box untill I enter different information in textbox.I will eventually have quit a few invoice spreadsheets in workbook,so I would want text box to refer to active sheet If you could help me with this I would appreciate it Thanks

[royUK]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Don't waste time for members, stick to the original post