Insert a textbox value into a cell in a worksheet

[BeginnerProgrammer]

Can someone tell me how to populate a cell in a worksheet with the value of a textbox on another worksheet in the same excel spreadsheet? Any help would be greatly appreciated.

Thanks

 

[kylua]

worksheets("Target Worksheet&quot.range("A1&quot.value = worksheets("source Worksheet&quot.textboxname.text

Add the textbox from the controls toolbox and place the above code into the Lost Focus event. Eg:

Private Sub TextBox1_LostFocus()
Worksheets(1).Range("A1&quot.Value = Worksheets(2).TextBox1.Text
End Sub