Transferring data entered into a Text box to another Cell/Sheet?

  • Thread starter Thread starter Alan T
  • Start date Start date
A

Alan T

Is it possible to record a macro that allows you transfer the data that
is entered into a text box to another cell/sheet?
 
You can't really record a macro that does this.

Private Sub Textbox1_Change()
Worksheets("Sheet1").Range("A1").Value = textbox1.Text
End sub

This uses the change event for the textbox. There may be better events to
use depending on what you want to do. Change is common to both a textbox on
the worksheet and in a userform. This assumes and MSforms.TextBox
 
Back
Top