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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell data entering slow! 0
Split form 0
Excel does not accept text format! 0
Link a text box based on drop down box with four options MS Word 365 0
Fixing text wrap in merged cells 1
Macro to Combine Data from Multiple Sheets with Cell References 4
Data from excel range to User form in textbox 2
Visio: copy text of a master shape to User-define Cells (Variable) 0

Top