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,