copy text box input into another text box automatically

S

Sigma Dan

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, [email protected]
 
B

BigPig

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
 
P

Pranav Vaidya

use change event of textbox 1 and set the text of textbox 2 same as text of
textbox1
 
Top