• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Linking the content of two text boxes

C

craymer

New Member
I have a very basic workbook with two worksheets. Both worksheets have two text boxes that will contain the same content. The text boxes will be filled out on the first worksheet. I would like the content to automatically appear in the text boxes on the second worksheet.

I have scoured Google to find an easy way to accomplish this task to no success. I would like to do it without VBA if possible. I created the text boxes using the "text box" button on the "insert" ribbon in lieu of a "control" from the "developer" ribbon. I found some threads that use both a VBA module, VBA class module, and a change event. Although I am not familiar with a change event.

Your help is greatly appreciated!
 
The TextBox is an Active X Control not a Form Control
TextBoxes also don't have a cell link
and so the text boxes can't be linked via Cells

If you double click the TextBox you will go to VBA and see the Textbox change event

Code: 
Private Sub TextBox1_Change()
 
End Sub

simply add a line to update the other text boxes

Code: 
Private Sub TextBox1_Change()
Textbox2.text=Textbox1.text
End Sub
 
You must log in or register to reply here.
Back
Top