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

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?
 
T

Tom Ogilvy

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
 
Top