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,

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

"Sigma Dan" wrote:

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,

use change event of textbox 1 and set the text of textbox 2 same as text of
textbox1
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer was useful, please rate this post!!


"Sigma Dan" wrote:

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,