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

Is it possible to record a macro that allows you transfer the data that
is entered into a text box to another cell/sheet?



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Transferring data 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

--
regards,
Tom Ogilvy


Alan T wrote in message
...
Is it possible to record a macro that allows you transfer the data that
is entered into a text box to another cell/sheet?



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/