Pull input from a text box to another tab in the workbook.

[stanleytheyak]

I am creating a QA form for my company. I've created a comments box and I would like to be able to pull anything that is entered in that box into a cell on a secondary tab as a training summary that can be printed out and given to an individual without having to print the entire form. Is this possible?

 

[Jerry Sullivan]

Yes, it's possible. If you want to use a button to trigger the copy of the comments box's text use...

Private Sub CommandButton1_Click()
    Worksheets("Training Summary").Range("A2") = TextBox1.Text
End Sub

If you want to copy of the comments box's text automatically any time it is changed, use....

Private Sub TextBox1_Change()
    Worksheets("Training Summary").Range("A2") = TextBox1.Text
End Sub

 

[stanleytheyak]

Exactly what I needed! Thank you!