User form data to 2 different places

[Chris Packet]

Is there any way can you send information enterd into a user form to two seperate worksheets and certain cells in these worksheets.
Is there any way around not being able to have two control sources or is there some useable VBA code? please help!

 

[erik.van.geit]

Chris Packet,

WELCOME to the Board.

Yes you can do that. What would you like to do precisely.
Provide some sample data, so we can adapt some code to your circumstances...

example:

Private Sub TextBox4_Change()
Sheets(1).Range("A1") = TextBox4
Range("yourrange") = TextBox4
End Sub

kind regards,
Erik

 

[whiteghost]

an alternative would be to have a macro copy and paste from the control soucre to the second worksheet.

but Erik's solution is much more tidy

 

[erik.van.geit]

In fact I don't like control source and prefer to feed the userform with the userform_initialize event.

Private Sub UserForm_initialize()
Textbox4 = range("yourrange")
End Sub

kind regards,
Erik