How to make one TextBox value equal another TextBox value?

**hmgrts** · 03-07-2013, 07:58 PM

Please see attached sample of the worksheet. Thanks!

**davesexcel** · 03-07-2013, 08:29 PM

This can be done with the Textbox from the activex controls. Rightclick on the sheet tab and select view code to see the code used in textbox1.
Your workbook will have to be saved as a macro enable workbook.

Typing in textbox 1 will automatically go to textbox 2

**hmgrts** · 03-09-2013, 01:45 AM

Thank you, great. I create another couple TextBoxes in second worksheet, and inserted

Private Sub TextBox1_Change()
TextBox2 = TextBox1
End Sub

but I don't understand, why it doesn't work... can you please check it?textbox1 to textbox2 Sample.xlsm