copy text box input into another text box automatically

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I use Excel 2003. I have a text box on worksheet 1 that is used to type in a
message. I want to automatically fill in another text box on worksheet 2 with
the same message. Anyone know how to do this? Thanks, (e-mail address removed)
 
Hi Sigma Dan,

Two ways:

First -no coding.

textbox1-properties-linked cell "=whichever cell you want"
the other txtbx in sheet2-properties-linked cell "=sheet1!the cell you
picked from above"

Second-a small bit of coding

I relabed the textboxes to txt1 and txt2 for the corresponding worksheets.
In the txt1 change event in sheet1 add this:

With Worksheets(2)
.txt2.Value = txt1.Value
End With

hth

BigPig
 
Back
Top