Results 1 to 5 of 5

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

Threaded View

nitram lowm Macro to copy textbox data to... 02-01-2013, 11:46 AM
stnkynts Re: Macro to copy textbox... 02-01-2013, 12:05 PM
nitram lowm Re: Macro to copy textbox... 02-01-2013, 01:45 PM
stnkynts Re: Macro to copy textbox... 02-01-2013, 04:58 PM
nitram lowm Re: Macro to copy textbox... 02-02-2013, 06:10 AM
  1. #1
    Registered User
    Join Date
    01-22-2013
    Location
    Ashford, England
    MS-Off Ver
    Excel 2007
    Posts
    9

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

    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.
    Last edited by nitram lowm; 02-05-2013 at 04:28 AM. Reason: more info

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1