Macro to copy textbox data to a duplicate textbox in another worksheet

**nitram lowm** · 02-01-2013, 11:46 AM

I have a workbook with two macro enabled worksheets, Sheet1Quotation, Sheet2Acceptance, Sheet2 is a straight copy of Sheet1 i just renamed it as Acceptance, so both are identical apart from the footers on each that do vary, both sheets have six TextBoxes named as TextBox1 - TextBox6 again they are of identical size and position on the two sheets. What i want is to automatically fill in the textboxes in sheet 2 as i enter text in the textboxes on sheet 1 to save me having to retype or copy/paste the information again in sheet 2. i use these two forms every day and it would save a lot of time. I have tried varoius methods and codes as suggested by members here and other forums, none work. Would it make a difference if the textboxes were inserted from the shapes sub menu rather that the text sub menu as i think i used that method on inserting some textboxes ? i have seen some code references which mention "Shapes" in the code as well as the sheet and textbox reference, or would it be easier to have all the text copied to sheet 2 with a command button once sheet 1 boxes are all complete ? HELP.

**stnkynts** · 02-01-2013, 12:05 PM

If you select "View Code" of TextBox1 on sheet "Sheet1Quotation" put this snipped in VBE that should pop up.

Please Login or Register  to view this content.

This will update everytime you make a change in TextBox1 on the first sheet. You will need to do this for each of the 6 TextBoxes and update the numbers accordingly.

**nitram lowm** · 02-01-2013, 01:45 PM

thanks for the reply, i've tried the code as mentioned but no luck, the code is now showing in view code on sheet1 but nothing is appearing in textbox1 on sheet2 ? i wondered if it was because textbox1 is inside another textbox(10) on sheet1 so i applied the code to other textboxes on the sheet1 that are freestanding giving the relevant reference numbers but id didn't work im them either ! might just be me, any ideas ?