Linking Textboxs

[zhb12810]

Hi

I have a textbox on sheet 1 named "TextBox1" and on sheet 2 I have another textbox also named "Textbox1"

Is there any code anyone could offer that links the 2 boxes together so that what ever is typed in sheet 1 appears on sheet 2.

I am aware of the linked cell option but do not want to go down this route

Many Thanks

[ducky_yeng]

I gave it go and found that I could use the TextBox1_Change() procedure of the ActiveX control to update the text box on the other sheet.

Please Login or Register  to view this content.

Hope that it correct and works for you.