How to enter data into two sheets in a workboot from one form

[selant]

I have a form (excel + vba) with some texboxes.
Is it possible to enter the first 3 textboxes data into SHEET1
and the other 3 textboxes data into SHEET2

And finally the workbook will return to SHEET1 back.

I would appreciate a sample code. Thank you

 

[Ed in Aus]

You may want to try something like this, go to VB and right click on the form where the text boxes are and go to view code... may need to adjust/add for text boxes as I only did this for a 3 boxes but you should get the point.

Private Sub TextBox1_Change()
    Sheets("sheet1").Activate
    Range("A1").Value = TextBox1.Value
End Sub

Private Sub TextBox2_Change()
    Sheets("sheet1").Activate
    Range("B1").Value = TextBox2.Value
End Sub

Private Sub TextBox3_Change()
    Sheets("sheet2").Activate
    Range("A1").Value = TextBox3.Value
    Sheets("sheet1").Activate
End Sub

notice the textbox3 refers back to sheet 1 this may look like it is not updating sheet 2 but it does. let me nkow if this is what you want

 

[selant]

this is exactly what i wanted. thank you.